Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
script or format to identify duplicate data
Is there a way I can write a script or conditional format to identify
duplicate data. The data can be marked by highlight if need be. Ex Since A1 and A3 are both the same numbers both locations become highlighted. I have a large range of data to perform this in. The numbers being identified are lager than 2 digits. A 1 12 2 13 3 12 Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
script or format to identify duplicate data
Conditional format would work fine:
With cell A1: Formula is, =COUNTIF(A:A,A1)1 Note that if you put this formula in the column next to your data, you could copy it down and then AutoFilter based on TRUE and whatever value is in column A to find all the duplicates. -- Best Regards, Luke M "Jeremy" wrote in message ... Is there a way I can write a script or conditional format to identify duplicate data. The data can be marked by highlight if need be. Ex Since A1 and A3 are both the same numbers both locations become highlighted. I have a large range of data to perform this in. The numbers being identified are lager than 2 digits. A 1 12 2 13 3 12 Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
script or format to identify duplicate data
Conditional Formatting
a) all version of Excel; Select the column of numbers (I will assume this is column A) and open the Conditional Formatting dialog. The formula you want to use is =COUNTIF(A:A,A1)1 and give a suitable format (light red fill, for example) b) in Excel 2007: select the column of data, open the Conditional Formatting dialog and locate "Format unique/duplicate..." and proceed from there. best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Jeremy" wrote in message ... Is there a way I can write a script or conditional format to identify duplicate data. The data can be marked by highlight if need be. Ex Since A1 and A3 are both the same numbers both locations become highlighted. I have a large range of data to perform this in. The numbers being identified are lager than 2 digits. A 1 12 2 13 3 12 Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identify duplicate rows | Excel Discussion (Misc queries) | |||
identify duplicate data upon entry of that data | Excel Discussion (Misc queries) | |||
Is there a macro to identify and remove duplicate data in Excel? | Excel Worksheet Functions | |||
identify duplicate enteries | Excel Worksheet Functions | |||
identify duplicate data in excel spreadsheet | Excel Discussion (Misc queries) |