I’ve been trying to figure this out for several days with no luck, I hope someone can help. If this can happen in Calc, that would be great, if it’s better handled in Base, I’ll be happy to try that solution, too.
Example data below. I have a sheet with about 3000 rows, I want to remove all rows for which an address was sold after 2010.
Some addresses have sold multiple times, but never after 2010–I want to keep all of those rows.
Some addresses have sold before 2010 AND after 2010–I want to remove those rows.
Some address have sold only after 2010–I want to remove those rows as well.
Thank you.
Date Sold Address Example criteria
2015-09-30 1000 Saw Mill
2015-05-18 1000 Saw Mill
2012-12-19 1000 Waterfall
2004-06-04 1009 Somerset Meadows All of this address’ sold dates are older than 2010, so I want to keep all of these rows in my spreadsheet.
2006-11-30 1009 Somerset Meadows
2002-04-22 1009 Somerset Meadows
2009-07-30 1009 Somerset Meadows
2016-10-13 1009 Spring Valley
2010-06-07 1010 Desert Sunflower
2017-05-30 1011 Saw Mill
2015-06-03 1011 Saw Mill
2015-10-16 1012 Desert Paintbrush
2008-10-21 1012 High Plains
2013-09-30 1012 High Plains
2017-07-20 1012 Saw Mill
2008-08-15 1013 Somerset Meadows
2017-02-03 1014 Spring Valley
2008-12-01 1014 Spring Valley
2011-05-17 1015 Waterfall
2011-08-26 1015 Waterfall
2013-11-26 1016 Clear Crk
2017-05-09 1016 High Plains
2017-06-30 1016 Saw Mill
2009-05-06 1017 Spring Valley One of this address’ sold dates is newer than 2010 so I want to remove both of these rows from my spreadsheet.
2011-11-28 1017 Spring Valley