Ask Your Question
0

How to pull data out of spreadsheet with multiple matching rows

asked 2017-10-21 19:27:03 +0100

Darrin Brunner gravatar image

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
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-10-23 16:56:00 +0100

erAck gravatar image

Use a filter (Data -> More Filters -> Standard Filter...), specify your Filter Criteria, and under Options check "Copy results to" and enter a cell address starting at which the data shall be populated.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-10-21 19:27:03 +0100

Seen: 104 times

Last updated: Oct 23 '17