Getting unique values from excel table

Question

I'm trying to apply these Getting unique values in Excel by using formulas only

to my table, but as a result i get only 0's

Can anyone help?

Thanks!

Answer 1

This should work:

1. Place =G1 in L1
2. Place {=INDEX($G$1:$G$999,MATCH(0,INDEX(COUNTIF($H$1:H1,$G$1:$G$999),0,0),0))} in L2 and copy it down.