Excel 2007 : Return Multiple Matches

Ok i just got done reading about 40 posts with similar titles, but non of them seem to really have anything to do with returning multiple matches.

so i have a list of LOCATIONS in column A

a list of PART Numbers in column B

and the QTY in column C.

sometimes the locations have the same part number. I have a search feature set up, i can look them up one by one and it auto filters but i would like to be able to make a list of everything i need, and it return the all the locations a certain part number is in.

Please Login or Register  to view this content.

i tried this but i dont really know what the hell it means.

Try this:

in an new column in SWITCH at row 2 enter:

Please Login or Register  to view this content.

where MAIN is the name of the other sheet where you have the search input value and D$1:D1 assumes you are entering this formula in D2.. adjust as necessary.

Then in an empty cell:

Please Login or Register  to view this content.

again where column D is where you entered the previous formula.

Now back on your main sheet.

Please Login or Register  to view this content.

WHERE MAIN!E2 is where you entered the MAX() formula...

copied down as far as you want.

The last formula should have been:

Please Login or Register  to view this content.

if still a problem, post a sample workbook.

I am now confused as to what you need. Please elaborate with your new workbook as to what exactly you are needing.

See attached.

I added some helper columns to find the matches...

In Master C5:

Please Login or Register  to view this content.

copied down, creates a list that counts each item in the list cumulatively.

In Counts E2:

Please Login or Register  to view this content.

copied down, gives total matches of each item

In Counts F2:

Please Login or Register  to view this content.

copied down and across as far as you need, gives matching locations.