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.
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.