UNIQUE and CHOOSECOLS return 0 for blank cells

Hi,

I want to avoid getting 0 when blank cells are met.

Current formula is:

Formula:

Please Login or Register  to view this content.

I believe I need to add SORT and/or FILTER to filter out the blank cells.

Have tried this but not working.

[FORMULA]=SORT(UNIQUE(CHOOSECOLS(FILTER(A2:A10;A2:A10;<>)A2:B10;1;2)[/FORMULA


Any suggestion on this?

Best,
Thomas

How about

Formula:

Please Login or Register  to view this content.