if function

[boogiman1981]

excel 2007

Ok I have a file that has part numbers and warehouse designators.

some of the part numbers are in both warehouses some are not.

how would i pair up the ones that are listed in both warehouses and hide or otherwise get rid of the ones listed in only one?

 

[Robert Mika]

Hi boogiman,
Please look at MATCH function.
http://www.techonthenet.com/excel/formulas/match.php

If this doesnot help please post exampleof your data