| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Filter based on a column of items
I have a range of data 500 rows high x 5 columns wide. I want to filter the
range by comparing the values in the first column to a separate range in 92 rows high (x 1 column wide). I want the whole range to therefore be 92 rows high x 5 columns wide, with the first column equal to the "lookup" range. I do not want to use Vlookup. |
|
#2
|
|||
|
|||
|
You might look at DataFilterAdvanced Filter.
HTH |:) On 8/22/05 5:16 PM, in article , "Pasko1" wrote: I have a range of data 500 rows high x 5 columns wide. I want to filter the range by comparing the values in the first column to a separate range in 92 rows high (x 1 column wide). I want the whole range to therefore be 92 rows high x 5 columns wide, with the first column equal to the "lookup" range. I do not want to use Vlookup. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running total w/2 columns - Excel | Excel Worksheet Functions | |||
| Adding total dollars based on specific data from another column | Excel Discussion (Misc queries) | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Count cells based on date range in another column | New Users to Excel | |||
| Count based on another column | Excel Discussion (Misc queries) | |||
Linear Mode
