Excel related query

[Shweta]

hi,
can someone please help with below query:

i have an excel file containing large amount of data like 6K, 7K. In that, there is a column of phone number (Col B). Now the requirement is to check if there is a duplicate entry for phone number, then col C needs to be updated with notes "Duplicate entry". Example:

Phone number:
9999999999
9999997777
8888888888
9999999999

So, I just need column C to be updated for first and last phone number.

 

[sahil_raina_91]

Assuming 1st Row is the header, apply this formula in cell C2, and autofill till last row :

=IF(COUNTIF($B:$B,$B2)>1,"Duplicate entry","")

 

[Shweta]

Thanks Sahil. Can you also please help with this query:
http://rpaforum.net/threads/cell-color-based-on-value.14148/#post-29787