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 |
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 |
All times are GMT +1. The time now is 02:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com