if you know a little bit of macro writing in Excel then copy this code and place it in a procedure:
Option Base 1
Application.ScreenUpdating = False
Dim tmp As Long
tmp = 0
a = Array("A", "B", "C", "D", "E", "F", "G")
For ctr = 1 To 7
Range(a(ctr) & 10).Select
If ActiveCell.Value > 3 Then
tmp = ActiveCell.Value
ActiveCell.Value = tmp
tmp = 0
Application.ScreenUpdating = True
The Option Base 1 declaration should be put in the declarations area. Make a button and assign it the name ShowGreaterHideLesser along with the code. The Array contains the columns A to G for example, and it starts at row 10 also as an example. You could change these ones later to suit your needs.
If you have questions don't be ashamed to ask. I might not be able to answer immediately if I'm at work. Hope this helps a bit.
I need to filter my results in a excel worksheet. I have a row of values representing profit in