Many times when we are working on very large data and we need to get sort it out. We need few trick help of excel formula. Below is a formula syntax for getting Unique record out of available data in excel sheet.
This is an example of countif formula to find out unique and duplicate value.Don't freeze the range.
=IF(COUNTIF(A2:A37,A2)>1,"Duplicate","Unique")
This is an example of countif formula to find out unique and duplicate value.Don't freeze the range.
=IF(COUNTIF(A2:A37,A2)>1,"Duplicate","Unique")
