FILTER function

Question

Hi all

I have created a basic FILTER function, as shown. It works fine, however, I've just realised that when the data doesn't meet the criteria I have specified, it simply returns nothing - not the text "No entries"? Can anybody see what I've done wrong? TIA, Louise

Answer 1

1. If you apply the FILTER formula to the range without the header row, it'll do what you want, Or use the formula that I proposed.
2. You might add FILTER to the UNIQUE formula to exclude 0 values.

Answer 2

As an aside, I have also used the UNIQUE function and have selected the whole column rather than just the data range. This works and does return a unique list of the range, however, because the whole column was selected, it also puts 0 at the end of the list of unique items because it is looking at the empty cells in that column. How do I ask it to ignore the empty cells, so I don't get the 0? Thanks again, Louise