Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding duplicate entries
I have a list of zip codes (thousands of them) in a
column, is there a command that will find duplicate numbers and turn them red? thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding duplicate entries
In french:
in conditionnal format: =nb.si($A$2:$A$1000;A2) in xl english nb.si=countif replace ";" by "," and chose a color conditionnal :-)) ....Patrick "Jack" a écrit dans le message de ... I have a list of zip codes (thousands of them) in a column, is there a command that will find duplicate numbers and turn them red? thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding duplicate entries
go to format/conditional formatting.
chose formula a put this: 'I am supposing your looked column is A:A =Countif(($A:$A);A1)1 then put a red format and "DONE -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding duplicate entries
=countif($A$2:$A$1000,A2) 1 !!!! sorry
"...Patrick" a écrit dans le message de ... In french: in conditionnal format: =nb.si($A$2:$A$1000;A2) in xl english nb.si=countif replace ";" by "," and chose a color conditionnal :-)) ...Patrick "Jack" a écrit dans le message de ... I have a list of zip codes (thousands of them) in a column, is there a command that will find duplicate numbers and turn them red? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Duplicate Entries | Excel Worksheet Functions | |||
Finding Duplicate Cell Entries | Excel Discussion (Misc queries) | |||
Finding duplicate entries | Excel Worksheet Functions | |||
Finding Duplicate Entries | Excel Discussion (Misc queries) | |||
Need help with finding duplicate entries | Excel Worksheet Functions |