Find unique values from a range using formula?

**FDibbins** · 02-13-2015, 11:14 PM

Not sure this would work on an array like that, but you could replace that array formula with this regular formula...
=IFERROR(INDEX($C$2:$C$60,MATCH(0,INDEX(COUNTIF($B$1:B1,$C$2:$C$60),0,0),0)),"")

Adjust ranges as needed

**djarcadian** · 02-14-2015, 10:34 AM

Originally Posted by FDibbins

Not sure this would work on an array like that, but you could replace that array formula with this regular formula...
=IFERROR(INDEX($C$2:$C$60,MATCH(0,INDEX(COUNTIF($B$1:B1,$C$2:$C$60),0,0),0)),"")

Adjust ranges as needed

Correct me if I"m wrong but it seems like this only working when the range is confined to a single column. If I expanded it as follows it didn't work for me.

=IFERROR(INDEX($C$2:$E$10,MATCH(0,INDEX(COUNTIF($B$1:B1,$C$2:$E$10),0,0),0)),"")

Example: https://docs.google.com/a/advantagep...it?usp=sharing