Filter Function...Is it capable?

[Jimmy110]

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

 

[Peter_SSs]

I've also tried to use the XL2BB add in but its not working?

In what way is it not working? What happens when you try?

 

[Jimmy110]

In what way is it not working? What happens when you try?

I just got a #Calc! Error… but it was because the area I wanted to filter was part of the original Array

 

[Peter_SSs]

I just got a #Calc! Error…

I was asking about in what way XL2BB was not working. I'm not sure that your answer to me was about that issue?

 

[Jimmy110]

I was asking about in what way XL2BB was not working. I'm not sure that your answer to me was about that issue?

Sorry…. I think I’ve got mixed up with my responses!

Thanks very much for trying to help out! Got there in the end

 

[Peter_SSs]

Got there in the end

Yes, but have you got XL2BB working so that you can use it if you have another question?

 

[Jimmy110]

Yes, but have you got XL2BB working so that you can use it if you have another question?

No, it’s still just greyed out on the task bar

 

[Peter_SSs]

No, it’s still just greyed out on the task bar

See if this helps: Xl2bb got disable

 

[Jimmy110]

See if this helps: Xl2bb got disable

Sorted! Thanks very much....was just not in a trusted location.

Cheers

James

 

[Peter_SSs]

Thanks very much....was just not in a trusted location.

Great. Glad you got it going.