| 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 |
Threaded Mode
