Creating unqiue list using INDEX(MATCH

System

This discussion was created from comments split from: Generate List of Unique Values - INDEX? DISTINCT? VLOOKUP?.

Venkatramana Reddy Kambalapalli

I am trying to create a unique list by removing duplicates followed Paul's steps.

Following is not returning any value. Please advise what is wrong

=IFERROR(IF(ISNUMBER(RowID@row), INDEX({CIS_SRF_Offshore CustomerName}, MATCH(RowID@row, {CIS_Offshore Helper}, 0))), "")