look at Data=Filter=Autofilter and filter on the Plant name.

--
Regards,
Tom Ogilvy


"John1950" wrote:


I have a spreadsheet with about 36,000 rows. They are parts we have in
stock at our 4 plants. Not all plants have the same parts. I have
sorted the sheet by part numbers; Problem. I want to identify the parts
that are used at the same plants.
Example

Plant Part Numbers
A abc123
B abc123
C abc234
D abc456
A abc567
B abc678
C abc678
D abc789
A abc890
B abc890
C abc890
D abc890


--
John1950
------------------------------------------------------------------------
John1950's Profile: http://www.excelforum.com/member.php...o&userid=18671
View this thread: http://www.excelforum.com/showthread...hreadid=522793