finding duplicates

[Legacy 169300]

I know how to remove duplicates in 07, but can't find an option to FIND them. I don't necessarily want to delete the duplicates, but I do want to see them. Is that possible?

 

[Trevor G]

Perhaps use a Countif Formula which will tell you, you could also use the Countif in Conditional Formatting.

Excel Workbook
	D	E
1	Peeps	Count
2	Harry	1
3	Sarah	2
4	Julie	2
5	Sarah	2
6	Julie	2
Sheet1

 

[Legacy 169300]

This helps Trevor, thanks. You'd think that if Excel can recognize duplicates to remove, we would have the option to 'find' them without having to use a formula! [frustrated]

 

[Alan C]

You can use a conditional format that will highlight the duplicates. If your data is in range A1:A500 highlight the range place this formula in the conditional format formula bar and use a color background to show duplicates. =COUNTIF($A$1:$A$500,A1)>1 Don't forget to format the color.

And yes, I agree, If Excel can find the dupes for you to delete, why can't a feature be added to just identify them.

Good luck.