duplicates

  • Thread starter Thread starter He cries for help
  • Start date Start date
H

He cries for help

I have a spreadsheet with three columns, each column has approximately 1200
cells
with part numbers entered into them. I would like to find duplicate numbers
across the columns and have them highlighted. Is this possible?
 
This is an application for conditional formatting. My understanding is that
you have a database that is 3 columns by 1200 rows and for any given row,
you'd like to highlight any duplicates in that row. Assuming that your first
row of data is in A1..C1,

1. Select cell A1 and click Format - Conditional Formatting.
2. Choose "Cell Value Is" "Equal To" and in the third box, type =B1
3. Click Format, choose a desired highlight color, and click OK.
4. Click the Add>> button and do the same thing except type =C1, then click
OK.
5. Repeat steps 1-4 for cells B1 and C1 except in B1 use =A1 and =C1 and for
C1 use =A1 and =B1.
6. Now highlight cells A1..C1, click Edit-Copy, then highlight cells
B2..C1200 and click Edit - PasteSpecial - Formats, and click OK

This will highlight any cell that has a duplicate value on the same row. If
I have misunderstood your objective, then please clarify.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicates Deletion ? 2
Duplicate Entries 3
How do I remove duplicates 7
Conditional Formula 3
Duplicates by groups 6
Conditional Formating - by row, not by column (Office 2007) 1
How can I count dates if few duplicates in a column 3
Conditional formatting 9

Back
Top