| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering data based on formula
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filtering based on a value in a cell | Excel Worksheet Functions | |||
| filtering data based on a formula | Excel Discussion (Misc queries) | |||
| data filtering based on last two digits of large number | Excel Worksheet Functions | |||
| Filtering Data With Formula | Excel Worksheet Functions | |||
| Filtering data from one worksheet based on another | Excel Discussion (Misc queries) | |||
Threaded Mode
