Good morning All.

I have the following formula (courtesy of Siva), that extracts a list of values from a database based on multiple values:

=IFERROR(INDEX(Database!M:M,SMALL(INDEX(((TRIM(Database!$A$2:$A$69)<>$A$2)+(TRIM(Database!$H$2:$H$69)="Capex"))*10^10+ROW(Database!$H$2:$H$69),0),ROWS(A$6:A6))),"")

It works brilliantly.

I need some help taking it one step further. How can I tweak this so that it produces a UNIQUE list; say maybe incorporating the frequency formula?

Thank you

H