Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicated cells
Hi! I'm looking for a simple formula to find (enhance, tag or so on), identical cells on a huge datasheet. In fe words, I've a 10,000 lines datasheet, made by one column with simple text. I can sort that column (i.e. ascending values), but I'd need also to immediately find duplicated text (one or more cells with the same text inside). Few time ago, I used a very simple formula, but... I've lost it. Is there anybody that could help me? Thanks a lot in the air! Ciao Claudio from Rome, Italy -- Claudiotto |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicated cells
Have a look at the formulas for highlighting or tagging dupes on Chip Pearson's
site. http://www.cpearson.com/excel/duplic...tingDuplicates Gord Dibben MS Excel MVP On Sat, 9 Sep 2006 16:50:12 +0100, Claudiotto wrote: Hi! I'm looking for a simple formula to find (enhance, tag or so on), identical cells on a huge datasheet. In fe words, I've a 10,000 lines datasheet, made by one column with simple text. I can sort that column (i.e. ascending values), but I'd need also to immediately find duplicated text (one or more cells with the same text inside). Few time ago, I used a very simple formula, but... I've lost it. Is there anybody that could help me? Thanks a lot in the air! Ciao Claudio from Rome, Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Merge Cells | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |