Hey all

My name is Mukun and im looking for help retrieving a unique set of text values from a list of 16 columns (80 rows). Column A contains the text values and Column B contains numeric values. This continues for 16 columns. there are duplicate text values and blanks in the list as well.

I would like to use a formula (or array formula) that retrieves only the unique text values (not unique number value) from the list into a single column. does not need to be alphabetical.

Is this possible?

I see there is an array formula for 3 columns

=IFERROR(IFERROR(IFERROR(INDEX($A$2:$A$20, MATCH(0, COUNTIF($D$1:D1, $A$2:$A$20)+($A$2:$A$20=""), 0)), INDEX($B$2:$B$7, MATCH(0, COUNTIF($D$1:D1, $B$2:$B$7)+($B$2:$B$7=""), 0))), INDEX($C$2:$C$12, MATCH(0, COUNTIF($D$1:D1, $C$2:$C$12)+($C$2:$C$12=""), 0))), "")

but how to expand to 8 columns?

Thanks!