Hi,

I recently started a major project for the company I'm working for, and
I've been struggling all morning trying to figure out how to get where
I'm going next.

Currently, I have all my columns, about twenty of them, in one
worksheet. They are side by side. It displays the part numbers that
different companies produce, and each column is for a different
company. I need some way to highlight the cells in each column that the
numbers are unique to that column alone, and aren't in any other column.


I also need a way to do a simple search and be able to sort and see
which companies produce a single part number. The columns have
different amounts of rows in them...some of them have over two thousand
part numbers, while some only have 30 or 40. How do I get excel to
compare all twenty of the lists to each other and highlight the part
numbers that only that company makes?


Thanks so much in advance....I've been working on this for about four
hours now and it's starting to make me mad.


I don't know if I have to put a macro in, or conditional formatting, or
what. I've done a lot of research and trial and error on it, and I can't
seem to find anything that will compare multiple ranges, and I really
don't know enough about excel to really get in and create my own
formula.

Any help would be greatly appreciated.....but I need detailed stuff,
like step-by-step in order to be able to do it right. Thanks!

-Sally


--
equinekingdom
------------------------------------------------------------------------
equinekingdom's Profile: http://www.excelforum.com/member.php...o&userid=33457
View this thread: http://www.excelforum.com/showthread...hreadid=532633