| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to check duplications in a single column
How to check duplications in a single column
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to check duplications in a single column
=COUNTIF(A:A,A1)1
-- David Biddulph "Burhan Uddin" wrote in message ... How to check duplications in a single column |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to check duplications in a single column
Watch word-wrap below but this formula in a cell other than the range
tested of A2:A7 works great - Enter as a Control+Shift-Enter type (CSE) - not just enter. CSE will wrap in { } 's for you. Jim May =IF(MAX(COUNTIF(INDIRECT("A2:A"&(MAX((A2:A7<"")*R OW(A2:A7)))),INDIRECT("A2:A"&(MAX((A2:A7<"")*ROW( A2:A7))))))1,"Duplicates","No Duplicates") "David Biddulph" <groups [at] biddulph.org.uk wrote in message : =COUNTIF(A:A,A1)1 -- David Biddulph "Burhan Uddin" wrote in message ... How to check duplications in a single column |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From single cell variables to a single column serie | New Users to Excel | |||
| Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
| Return Single Row of Numeric Data to Single Column | Excel Worksheet Functions | |||
| remove duplications | Excel Discussion (Misc queries) | |||
| How do I check for duplications in a range of data (excel)? | Excel Worksheet Functions | |||
Linear Mode
