basic Autofilter question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, Question example: In cell A1 is the value of 50. I click on A1 to Autofilter. When sorting the column using the "custom Autofilter" window, what code do I put in the upper right and lower right fields if I want to find data for example that is a value of 10 higher and a value of 10 lower than the 50 in A1? Also, what goes in the left upper and lower fields
Then I want to select B1 with a value of 100 and do the same thing of 10 above and 10 below. Is it possible to sort like this
I appreciate anyone who can help!
 
In a custom AutoFilter, you can't refer to a cell on the worksheet, so
you can't filter for cells within a specific range of the value in cell A1.

You could add a column to the table, and calculate whether or not each
row meets the criteria. For example, insert a column to the right of A,
and enter this formula in cell B2: =AND(E2>=$A$1-10,E2<=$A$1+10)
Then, filter column B for TRUE.
 
Add a heading in cell D1, e.g. 'Test'
Enter the following formula in cell D2:
=AND(A2>=A$1-10,A2<=A$1+10,B2>=B$1-10,B2<=B$1+10,C2>=C$1-10,C2<=C$1+10)

and copy down to the last row of data

Filter column D for TRUE
 
Back
Top