K
Krys
Hi, I want to filter a table of data to display rows with values between two
numbers but the numbers will change as it is used, so the criteria values
have to be in the form of a formula.
ie.
A1 = Manually inputted data (eg 1)
B1 = Manually inputted data (eg 7)
A2 = A1
B2 = B1
F7 = "Day"
F8-F12 = Data (eg 2, 5, 1, 4, etc)
G7, H7 etc more data
How do I filter F7:H12 with the criteria that values in column F are =>A2
and =<B2?
numbers but the numbers will change as it is used, so the criteria values
have to be in the form of a formula.
ie.
A1 = Manually inputted data (eg 1)
B1 = Manually inputted data (eg 7)
A2 = A1
B2 = B1
F7 = "Day"
F8-F12 = Data (eg 2, 5, 1, 4, etc)
G7, H7 etc more data
How do I filter F7:H12 with the criteria that values in column F are =>A2
and =<B2?