Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Faster way to check and sort duplicate numbers
I have been using COUNTIF(A:A,A#) to check for doubles for a while now. The
formula works fine for small ranges of numbers, but really starts to lag after 4000 numbers or more. Well, now I am having to deal with serial number ranges of 10-60000 and my formula is no longer practical. Is there a faster way to identify multiple (up to 5 or so) occurences of the same number(with alpha characters) in a column? Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check for duplicate numbers | Excel Worksheet Functions | |||
check a list of numbers for duplicate entries in Excel | Excel Discussion (Misc queries) | |||
Faster way to duplicate worksheet with sequence ??? | Excel Discussion (Misc queries) | |||
how can I check a worksheet for duplicate entries or numbers? | Excel Worksheet Functions | |||
How do I check for duplicate numbers in Excel? | Excel Discussion (Misc queries) |