Formula to display repeated values

[Richard Dodd]

=IF(COUNTIF(A:A,A1)>1,"Repeated","") Worked on Excel 2003. Does not appear to work on 2007

 

[Greg Truby]

Works for me just fine. Sure you wanna look at A1 and not some other cell?

Also, are you aware that XL2007 has a build-in option for conditionally formatting repeated values?

 

[Richard Dodd]

Thanks Greg for the prompt reply. Yes, I tried other columns rather than A. I thought it might be a format problem. That wasn't it either. So still am not sure. I only recently had 2007 installed so am unaware of the conditional formatting. If you can direct me, much appreciated.

 

[Greg Truby]

On the home tab, in the styles group, you have the button for conditional formatting. Click that and you'll get a dropdown menu, the first menu option is Highlight Cells Rules, pick that and your last option on the flyout is Duplicate Values...

 

[Richard Dodd]

Outstanding. Thank you.