msft excel

greg karsa February 6, 2009 at 08:28:29
Specs: Windows XP
i have duplicate records in a column I want to remove the duplicate numbers, I also want to indentify what numbers are duplicated. I do not want to move the cells up or down please help

See More: msft excel

Report •

February 6, 2009 at 10:26:56
Try this:

1st - Highlight Column Data Cells
I.E. Cells A1 thru A100

On the Menu Bar select:

2nd - Format
3rd - Conditional Formatting
4th – Change “Cell Value is” to “Formula Is”
5th – Enter the formula:


Sub Menu Format :
6th - Patterns
7th - Choose a pretty color
8th - Press OK
9th - Press OK

All your duplicate records should now be highlighted.


Report •
Related Solutions

Ask Question