G Guest Oct 19, 2007 #1 After sorting a big table I need to find the duplicates that appears in a special column? Do anybody know?
After sorting a big table I need to find the duplicates that appears in a special column? Do anybody know?
G Guest Oct 19, 2007 #2 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
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
