Formula to find conditional formatting

[Pranesh]

Hello All,

I have a conditional formatting applied in column C to highlight the duplicate values. Now I need a IF formula in column A to say whether column C value is duplicate or unique. Can someone help me with the formula.

 

[Pranesh]

If you can sort the data on column C, then you can use a simple formula like:

=IF(OR(C2=C1,C2=C3),"Duplicate","Unique")

in say D2 (I'm assuming you have a header row) and copy it down.

Hi RoryA,

You are a genius. It worked out perfectly and took only 1 second to do the calculation. Thank you so much for your assistance.

Can you make me understand one more things. I previously did a double vlookup it was also too fast in calculating. But after 4 to 5 instances it took around 15min to run it. What will be the possible reason for this slowness.

 

[RoryA]

What do you mean by "4 to 5 instances"?

 

[Pranesh]

What do you mean by "4 to 5 instances"?

I Mean that I have included double Vlookup formula in a VBA. If I open the file for the 1st time and run the macro it takes only 2min to calculate. The same way if im running the macro for the 4th or 5th time it is taking nearly 15-20 min to calculate.

I need one more help from you. I have created a thread on 11th but I didn't get reply from anyone. Can you check and help me with that as well? Below is the thread link.

https://www.mrexcel.com/forum/gener...yperlink-collapse-email-body.html#post5259085