Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Date Range
0 views
Skip to first unread message
Looping through
Nov 27, 2007, 2:21:02 PM11/27/07
to
Is there a way to write a formula that looks at a certain date listed in my
spreadsheet and Mark that row somehow for a filter or sort to look at later.
spreadsheet and Mark that row somehow for a filter or sort to look at later.
My constant date range will be in cell W2
My changing date cell will be in cells R3:R10000
I want to basically filter and look at only the rows inserted in the last 30
days.
Thanks in Advance
Peter
Pete_UK
Nov 27, 2007, 2:30:27 PM11/27/07
to
In a helper column you can add a formula like this one:
=IF(R3>=TODAY()-30,"recent","old")
and copy down. Then apply a filter to this column, selecting "recent",
i.e. within 30 days of today's date. I'm not sure what is in W2.
Hope this helps.
Pete
On Nov 27, 7:21 pm, Looping through
0 new messages