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 the 00/01/1900 or blanks but the list is missing lots of entries.
=(SORT(UNIQUE(FILTER(G:G,G:G<>" "),,TRUE)))
Can anyone tell me what I am doing wrong please?
4 Replies
=SORT(UNIQUE(FILTER(G:G,G:G<>"")),,1)
This formula returns the intended result in my sheet.
- 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?
