Formula to flag duplicates ignoring initial entry

[NikiDivi]

Hello and good morning.

I'm using =IF(COUNTIF(F:F,F35)>1,"Duplicate","Initial") to flag duplicates but want the first entry to be labeled initial. Currently, all duplicates, including the initial entry, are being flagged as duplicates. I appreciate your time and assistance.

Thank you,
Nicole

 

[Fluff]

How about

=IF(COUNTIF(F$35:F35,F35)>1,"Duplicate","Initial")

 

[NikiDivi]

That doesn't seem to work. I have 7500 rows of data and even if I change it to =IF(COUNTIF(F:F,F7500)>1,"Duplicate","Initial") it still doesn't work. I want the formula in Column C to search Column F for duplicate values and return duplicate only for the 2nd and subsequent duplicates.

 

[Fluff]

What row are you putting the formula into?

 

[NikiDivi]

What row are you putting the formula into?

Row 4

 

[Fluff]

In that case it needs to be

=IF(COUNTIF(F$4:F4,F4)>1,"Duplicate","Initial")

 

[Rick Rothstein]

The formula @Fluff gave you is meant to be copied down to the end of your data. Are you looking for a single formula that will spill the entire result for you? If so, give this a try (note that you will have to specify the actual range, not the entire column, so change the range as appropriate)...

=MAP(F4:F7500,LAMBDA(x,IF(COUNTIF(F4:x,x)>1,"Duplicate","Initial")))

 

[NikiDivi]

That works, thank you. Can you quickly explain why it works?

 

[Fluff]

In future, please do not put your reply inside quotes. Just use the quick reply window at the bottom of the page.

It works by counting how many matches there are on the current row & above.

 

[NikiDivi]

=MAP(F4:F7500,LAMBDA(x,IF(COUNTIF(F4:x,x)>1,"Duplicate","Initial")))

Thank you for your reply. I entered =MAP(F4:F7500,LAMBDA(x,IF(COUNTIF(F4:F7500,F4)>1,"Duplicate","Initial"))) because the data that I'm searching for duplicates is in Column F, rows 4 through 7500. Is this correct?