| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find duplicates with left 4 characters
Hello all,
I have a need to find duplicates in a column where only the left four characters match. I read through the posts and found the following formula on Chip Pearson's website (thanks Chip), but have been unable to successfully modify it to indicate when the left four characters match for the concatenated text cells in the range. Can anyone provide assistance? Thanks for your help, Bruce =IF(MAX(COUNTIF(INDIRECT("c39:C"&(MAX((c39:c47<"" )*ROW(c39:c47)))), INDIRECT("c39:c"&(MAX((c39:c47<"")*ROW(c39:c47))) )))1,"Duplicates","No Duplicates") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get characters on left of specified character in Excel | Excel Discussion (Misc queries) | |||
| Excel 2003, SUM left-most characters | Excel Worksheet Functions | |||
| Easiest way to extract characters in a cell LEFT or RIGHT of a sym | Excel Worksheet Functions | |||
| In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
Threaded Mode
