| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I check for duplications in a range of data (excel)?
I have a large list of Alpha/numeric codes and I need to determine if any of
the codes are duplicated. Of course I have sorted the column and done if manually but the list is up to 4000 rows long (a monthly occurance) and i almost make myself blind doing it by eyesight.I have tried IF formulae but to no avail, I am a little stuck and even our IS department are unsure as to what to do. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| How can I check if data in external data range is changed after re | Excel Discussion (Misc queries) | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
