Thread: Advanced Filter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chad Portman Chad Portman is offline
external usenet poster
 
Posts: 36
Default never mind

I just found the custom option on the auto filter which allows me to select
greater than and then type a condition which in this case was 432000 and that
works great but thanks anyways.

"Chad Portman" wrote:

Ok so I have another huge sections of data that I need to filter. This time
the column that I need to filter off of has a list of times that the ticket
has been active in seconds. I need to filter out all tickets open less then
120 hours so that the only ones I have left are those that have been open 120
hours or greater. Is this even possible?

P.S.

Excel 2003