R
Roger Govier
Hi
Try
<>""
Try
<>""
P
Peo Sjoblom
Use
A1
ate Received
A2:<>
Regards,
Peo Sjoblom
A1
ate ReceivedA2:<>
Regards,
Peo Sjoblom
P
Peo Sjoblom
It filters out blank cells, so maybe your cells are not blank (Maybe
spaces or other invisible characters)? I know it works for retrieving
non blank cells. The only other filter option is to use a formula in the
criteria range
You can also drop the header in A1 and put this in A2
=A6<>""
where A6 is the first data cell in the list you want to filter,
so if the header is in A5 A6 would be the first data cell
It's important that the top cell in the criteria range is empty when you
use a formula but it has to be included in the criteria range
nonetheless. If that doesn't work check some of your "blank" cells use
=LEN(A6)
if it is blank it should return zero
Regards,
Peo Sjoblom
spaces or other invisible characters)? I know it works for retrieving
non blank cells. The only other filter option is to use a formula in the
criteria range
You can also drop the header in A1 and put this in A2
=A6<>""
where A6 is the first data cell in the list you want to filter,
so if the header is in A5 A6 would be the first data cell
It's important that the top cell in the criteria range is empty when you
use a formula but it has to be included in the criteria range
nonetheless. If that doesn't work check some of your "blank" cells use
=LEN(A6)
if it is blank it should return zero
Regards,
Peo Sjoblom