Filter tool

**8rowni** · 02-08-2012, 08:41 AM

Hi,

I use a spreadsheet to log date etc and use filter a lot!

One of the columns (column U) is a column I use to input a date, sometimes I input a date and sometimes I input NA when not applicable.

Up until today I have been able to filter column U by date so for example I filter down on all cases of specefic month...as of this morning even when I choose to filter down on a specefic month it is including "NA" cases...

Can anybody help?

Thanks,

**TMShucks** · 02-08-2012, 09:07 AM

Hello and welcome to the forum.

I suspect that the filter is not including all the rows. Switch it off, make sure all the rows are selected and switch it on again. Are there any blank rows in the middle of the data? If there are, that will break the area up and will only filter on the first area.

Please note, however ...

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

**8rowni** · 02-08-2012, 09:39 AM

Thanks for the info.

Yes there are blanks in some on some of the rows but this hasnt affected it up until now...

How do I make sure sure all the rows are selected? Unless you mean clicking and draggin the cursor over the whole of the spreadsheet....

Thanks