Perform an advanced filter based on the criteria range. Filter the existing database in place.

H 5 File Home Insert Draw Page Layout Formulas Data Review View Power Pivot Tell me what you want to do dx cut Calibri Et Wrap Text General Co Paste Conditional Format as Cel Format Painter Formatting Table Clipboard Fon Alignment Number Criteria Range Unit Unit ABed Rental Price occupied Last Remodel Recommendation 103 Rolling Meadows 850 No Need to remodel 406 Mountaintop View 3 1.200 No 2002 Need to remodel 505 Sunset Valley 2 700 No 2003 Need to remodel Database Statistics List of Rental Property Rolling Meadows 2004 No change 108 Rolling Meadows 2 850 No 1999 Need to remodel 104 Rolling Meadows 2 850 Yes 2005 No change 105 Rolling Meadows 3 1.000 No 2007 No change 302 Lakeview Apartments 1 875 No 2001 Need to remodel 303 Lakeview Apartments 1 900 No 2001 Need to remodel 306 Lakeview Apartments 2 1.200 Yes 2004 No change 406 Mountaintop View 3 1.200 No 2002 Need to remodel 407 Mountaintop View 2 975 Yes 2002 No change 408 Mountaintop View 2 975 Yes 2002 No change 501 Sunset Valley. 1 550 Yes 2010 No change 502 Sunset Valley. 1 550 No 25 2010 No change 503 Sunset valley 1 550 No 2003 Need to remodel 26 504 Sunset Valley. 1 550 Yes 2003 No change 505 Sunset Valley. 2 700 No 2003 Need to remodel Summary Database Loan Ready Sign in 2 Autosu A nsert Delete Format Sort & Find Clear lter Select Editing share