Excel formula error in the excel

Hi, In the first column I am writing the Duplicate/uniqe, but if you see only the highlited rows are uinique, but if you see 101 & 102 two times so it should written duplicate, can you help.
image

@Palaniyappan @HareeshMR

1 Like

may i know what we need here
do we need only unique value or what
kindly elaborate that
Cheers @balkishan

1 Like

I want if the row is containing duplicate data, then I want to write duplicate, if the row is unique then write unique in first column,

If you see in the first column it’s written Unique for all rows, If you see row 1,2,3,4 are having duplicate value. @Palaniyappan

@balkishan

Can you let me know if you want to check any particular column or all the columns data in the excel?

@balkishan,

Sounds interesting.

I had come across something like this some time back!

Just for confirming, do you need “Duplicate” in Both the copies or only second copy?