Forum Discussion
Unique sorted filter
Hi, If I use the formula below I get a complete list but with blank cells and 1 cell with 00/01/1900. =SORT(UNIQUE(FILTER(G:G,G:G<>" "))) If I change the formula to the 1 below I don't get t...
Sorry. I found some cells with leading blanks.
=SORT(UNIQUE(FILTER(G:G,(G:G<>"")*(LEFT(G:G,1)<>" "))),,1)
Do you want to exclude cells that start with a leading blank such as G17 and G18 in the example?
- I've amended them. Thanks.