Hi
I'm using =FILTER function to create a spilled column with numbers in Column A and Date and Time stamps in column B.... Is there a way to create another Filter function off the already filtered column? (Without selecting filters in the standard way as I cant have any of the data disappear in the lines that get hidden when filtering this way?)
The reason I ask, is I want to filter column A & B again if its todays date in column B?
Cheers
James
I'm using =FILTER function to create a spilled column with numbers in Column A and Date and Time stamps in column B.... Is there a way to create another Filter function off the already filtered column? (Without selecting filters in the standard way as I cant have any of the data disappear in the lines that get hidden when filtering this way?)
The reason I ask, is I want to filter column A & B again if its todays date in column B?
Cheers
James