Dear reader,
I'm using this formula in a different sheet to pull values but filter out those cells with 'No defined output." from my main sheet:
And it's working, but the column AA has multiple duplicate values. I'm trying to make a shortlist with only unique values displayed.
Any help is much appreciated!
Regards,
Steve
I'm using this formula in a different sheet to pull values but filter out those cells with 'No defined output." from my main sheet:
Excel Formula:
=IFERROR(INDEX(Tickets!AA9:AA209;MATCH(TRUE;INDEX((Tickets!AA9:AA209<>"No defined output.");0);0));"")
And it's working, but the column AA has multiple duplicate values. I'm trying to make a shortlist with only unique values displayed.
Any help is much appreciated!
Regards,
Steve