Heres what I need
cell a5:a404 contains Names
cell b5:b404 contains Dates
cell c5:c404 contains Status
Example Data
Names Date Status
John 7/25/05 Active
Fred 7/28/05 Pending
Mike 8/12/05 Active
In cells a410:c412 i'd like to filter for the oldest active records.
Names Date Status
John 7/25/05 Active
Mike 8/12/05 Active
I can't just use the auto filter option, I need the values to be in that
specific cell range. Thanks for any help.
Bookmarks