Finding duplicate nuumbers in a column
Is there a formula to find duplicate numbers in columns in excel
|
Do you want to find them or remove them
to find them =IF(COUNTIF($A$1:$A$20,A1)1,"Duplicate","") in a help column copy down and it will tag each number/value that occur more than once. If you only want to tag from the second occurrence =IF(COUNTIF($A$1:$A1,A1)1,"Duplicate","") both formulas should be copied down if you just want to remove any duplicates and get a unique number column use dataadvanced filter and unique records only Regards, Peo Sjoblom "Johnny the hat" wrote: Is there a formula to find duplicate numbers in columns in excel |
Thank You
"Johnny the hat" wrote: Is there a formula to find duplicate numbers in columns in excel |
All times are GMT +1. The time now is 01:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com