View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg
 
Posts: n/a
Default Simplifying Formula (part 1)

You could use Advanced Filter
which needs only one formula in one cell.
Assume you want to filter today's date out of your list:

ListA
4/22 4/22
4/21 4/22
4/22 4/25
4/25 4/25
4/25 4/23
4/21 4/25
4/21 4/26
4/23 4/25
4/25
4/26
4/21
4/25

Criteria
Test
TRUE

Name ListA (12 cells) and Criteria (2 cells)
Where it says TRUE enter this formula:
=NOT(ListA=TODAY())