Bob789
12-26-2018, 05:57 PM
I want to extract all rows that do not = 0 from the below table and want to extract to a different location. Would like to use formulas to setup a spreadsheet to have an employee use on a monthly basis so it is very simple for the employee to use.
Account #
Account Descript
Amount
1.500100
Building Maintenance
0
1.500137
Building Damage Repair
0
1.500400
Painting
0
1.500705
Plumbing/Sewer
10.5
1.501000
Electrical
0
1.501310
Lighting
127.27
1.501450
Carpet Cleaning
0
1.501805
Balconies/Decks
0
1.502100
Roof
0
1.502505
Gutters
1050.75
Account #
Account Descript
Amount
1.500100
Building Maintenance
0
1.500137
Building Damage Repair
0
1.500400
Painting
0
1.500705
Plumbing/Sewer
10.5
1.501000
Electrical
0
1.501310
Lighting
127.27
1.501450
Carpet Cleaning
0
1.501805
Balconies/Decks
0
1.502100
Roof
0
1.502505
Gutters
1050.75