| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to retrieve multiple rows with one criteria
Hi,
I have more than 1000 rows of data and the very first column has more than 100 values (i.e. Pencil shows in Cell A2, A18, A95, A357 and a number, 100, shows in Cell A5, A58, A754, A951 and the rest of values has similar entries in different cells in the first column. I am trying to get the all the rows of data with Pencil in the first column when I type Pencil in a cell. Vlookup doesn't work since it only takes the very first cell that has Pencil. Filter doesn't work well since there are two many values to choose from. How do I set up a formula that retrieves a multiples rows of data with the same one criteria in the first column? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to retrieve multiple values in multiple rows with one criteria | Excel Discussion (Misc queries) | |||
| retrieve multiple results with one criteria... | Excel Discussion (Misc queries) | |||
| Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
| Summing Rows with Multiple Criteria | Excel Worksheet Functions | |||
| How can I retrieve multiple rows that match one criteria, i.e. a d | Excel Worksheet Functions | |||
Threaded Mode
