| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
NO REPEATS
I have about 700 8 digit codes that are sorted numericaly. I received an
additional 2,600. My problem is that some of these new #'s are repeats of my own. Someone told me to do a "V LOOKUP". What is that and how do I do it?????????? -- HOMER |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
NO REPEATS
Hi Homer,
If you put all the numbers into column A, starting at row 1, the following formula, put into B1, and copied down to the last row, will put an exclamation mark in that column for any duplicates: =IF(SUMIF($A1:A1,A1)1,"!","") If you then sort both columns by column B, the duplicates will be on successive rows (at the bottom, by default) and you can then delete those rows. -- Cheers macropod [MVP - Microsoft Word] "HOMER" wrote in message ... I have about 700 8 digit codes that are sorted numericaly. I received an additional 2,600. My problem is that some of these new #'s are repeats of my own. Someone told me to do a "V LOOKUP". What is that and how do I do it?????????? -- HOMER |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
NO REPEATS
With a slight variation this formula in B2 it will put "!" beside the dups
=IF(SUMIF(A$1:A1,A2)1,"!","") "HOMER" wrote: I have about 700 8 digit codes that are sorted numericaly. I received an additional 2,600. My problem is that some of these new #'s are repeats of my own. Someone told me to do a "V LOOKUP". What is that and how do I do it?????????? -- HOMER |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
NO REPEATS
Hi Patty,
Coded that way, the formula could put the '!' on the wong line (ie the line after the duplicates), especially if the list hasn't been sorted. You'll note that, with the solution I posted, it can be used before the list is sorted (ideally, row 1 would be the header row, which doesn't get sorted). -- Cheers macropod [MVP - Microsoft Word] "Patty" wrote in message ... With a slight variation this formula in B2 it will put "!" beside the dups =IF(SUMIF(A$1:A1,A2)1,"!","") "HOMER" wrote: I have about 700 8 digit codes that are sorted numericaly. I received an additional 2,600. My problem is that some of these new #'s are repeats of my own. Someone told me to do a "V LOOKUP". What is that and how do I do it?????????? -- HOMER |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| No repeats of name in same colum | Excel Discussion (Misc queries) | |||
| Macro repeats and then stops | Excel Discussion (Misc queries) | |||
| Unwanted Repeats | Excel Worksheet Functions | |||
| Count repeats | Excel Worksheet Functions | |||
| no repeats in a column | Excel Worksheet Functions | |||
Linear Mode
