Hello,
I have this formula that works fine to list in alphabetical order:
=IFERROR(INDEX(B$3:B$11,AGGREGATE(15,6,(ROW(B$3:B$11)-ROW(B$3)+1)/(B$3:B$11<>""),ROWS(D$3:D3))),"")
Could anyone help me to adapt this formula so that it also returns only unique values?
I need it not to be a array formula.
Thanks
I have this formula that works fine to list in alphabetical order:
=IFERROR(INDEX(B$3:B$11,AGGREGATE(15,6,(ROW(B$3:B$11)-ROW(B$3)+1)/(B$3:B$11<>""),ROWS(D$3:D3))),"")
Could anyone help me to adapt this formula so that it also returns only unique values?
I need it not to be a array formula.
Thanks