Help with Highlighting Data

J

John1950

I have a spreadsheet with about 36,000 rows. They are parts we have i
stock at our 4 plants. Not all plants have the same parts. I hav
sorted the sheet by part numbers; Problem. I want to identify the part
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 abc89
 
S

SteveG

You can use Conditional Formatting to find duplicates which is what i
seems like you want to do. In B2 go to the Format menu, selec
Conditional Formatting. Change the Cell Value is option to Formula i
and type in,

=COUNTIF($B$2:$B$36000,B2)>1

Click on Format, Font, change the font color to whatever you want.
Click OK and OK.

You can then use the format painter to apply this to the rest of you
list.

HTH

Stev
 
G

gjcase

Suggest your best bet is a pivot table. I'd put Plant in the firs
column, Part No along the top, and Count of parts on the interior dat
portion of the table. (If Excel suggests Sum of Part Numbers when yo
drag the Part No button to the data area, double click it & you ca
change it.)

This woo produce a table of Part Numbers with a tally of number of eac
produced at each Plant as follows:

Count of Plant Plant
Part A B C D Grand Total
abc123 1 1 2
abc234 1 1
abc456 1 1
abc567 1 1
abc678 1 1 2
abc789 1 1
abc890 1 1 1 1 4
Grand Total 3 3 3 3 12

---Glen
 
Top