Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find multiple results
I'm trying to set up a spreadsheet that will give me the multiple and
various results from a column in a spreadsheet. Example spreadsheet: col a col b Part Tool 12345 12345 23456 23456 34567 34567 45678 34567 56789 56789 67890 56789 78901 56789 if I was to search for all parts made from tool 12345 the result should be only part 12345, but if I searched for parts made from tool 56789, the results I'm looking to see are 56789, 67890, and 78901. I was able using index and match funtions to get a single answer but I would like to be able to display all associated results on the single worksheet. Maybe it's some kind of combination of if statements and index and match functions or find, I'm not sure. My spreadsheet has approximately 1000 part numbers made from several hundred different tools. Thanks in advance for the assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find multiple cells/replace whole cells w/data | Excel Discussion (Misc queries) | |||
Searching for multiple results in one cell | Excel Worksheet Functions | |||
how do you find the SD(standard deviation ) for the multiple reg | Excel Worksheet Functions | |||
Return Multiple Results with Lookup | Excel Worksheet Functions | |||
Displaying the results of multiple formulas in a single cell. | New Users to Excel |