|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 4th, 2010, 12:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicates
I trying to use a formula to find Duplicates Entries in a Single Column. I
tried some formulas I found it but they didn't work. 
|
|
#2
March 4th, 2010, 12:45 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Duplicates
Let me Clarify The Item may be listed several times. Possible 12 times.
Such as Blue Red Blue Yellow Blue Green Blue So I would need to know every time Blue shows up. My goal is to delete all but one of the Items. "klafert" wrote: I trying to use a formula to find Duplicates Entries in a Single Column. I tried some formulas I found it but they didn't work.
|
|
#3
March 4th, 2010, 12:54 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Duplicates
Assuming that your first Blue entry is in A2, put this formula in another
cell on row 2 =COUNTIF(A$2:A2,A2) and fill the formula down the list. At the 1st entry for any value in column A the value will be 1. Then you filter on that column to display entries with a value of 1 and copy the displayed information to another sheet, which will give you a list of unique entries. "klafert" wrote: Let me Clarify The Item may be listed several times. Possible 12 times. Such as Blue Red Blue Yellow Blue Green Blue So I would need to know every time Blue shows up. My goal is to delete all but one of the Items. "klafert" wrote: I trying to use a formula to find Duplicates Entries in a Single Column. I tried some formulas I found it but they didn't work.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
