To find duplicates in XL sheet?
Hi
Select your data (in this example A1 - A100) then click
Format|conditional format
select formula is
enter this formula
=COUNTIF($A$1:$A$100,A1)1
Pick a colour and duplicates will be hughlighted.
Mike
"Ina Andersson" wrote:
After sorting a big table I need to find the duplicates that appears in a
special column? Do anybody know?
|