| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dupplicates
Hi
I have in column A the data. In column B I would like to set the formula that check if there are dupplicates. I tried this =COUNTIF(B$1:B2,B2)=2 but it doesn't show me the first item that has dupplicates. Do you know how to solve this problem? Thanks -- Greatly appreciated Eva |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dupplicates
You said you have data in ColA.....In ColB cell B1 try the below formula and
copy down as required. =IF(COUNTIF(A:A,A1)1,"Duplicate","") If this post helps click Yes --------------- Jacob Skaria "Eva" wrote: Hi I have in column A the data. In column B I would like to set the formula that check if there are dupplicates. I tried this =COUNTIF(B$1:B2,B2)=2 but it doesn't show me the first item that has dupplicates. Do you know how to solve this problem? Thanks -- Greatly appreciated Eva |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dupplicates
Works. Thank you very much!
Eva -- Greatly appreciated "Jacob Skaria" wrote: You said you have data in ColA.....In ColB cell B1 try the below formula and copy down as required. =IF(COUNTIF(A:A,A1)1,"Duplicate","") If this post helps click Yes --------------- Jacob Skaria "Eva" wrote: Hi I have in column A the data. In column B I would like to set the formula that check if there are dupplicates. I tried this =COUNTIF(B$1:B2,B2)=2 but it doesn't show me the first item that has dupplicates. Do you know how to solve this problem? Thanks -- Greatly appreciated Eva |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dupplicates
If this is your data:
A1: 1 A2: 1 A3: 2 A4: 3 A5: 3 What results do you expect? -- Biff Microsoft Excel MVP "Eva" wrote in message ... Hi I have in column A the data. In column B I would like to set the formula that check if there are dupplicates. I tried this =COUNTIF(B$1:B2,B2)=2 but it doesn't show me the first item that has dupplicates. Do you know how to solve this problem? Thanks -- Greatly appreciated Eva |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
