I need to filter/flag data based on the result of the subtotal eg.
row
1 0
2 0
3 sub total 0
4 0
5 100
6 sub total 100
the criteria to filter/flag as true is where sub total equal to 100, so the result needs to be rows 4 & 5.
I need to filter/flag data based on the result of the subtotal eg.
row
1 0
2 0
3 sub total 0
4 0
5 100
6 sub total 100
the criteria to filter/flag as true is where sub total equal to 100, so the result needs to be rows 4 & 5.
Last edited by scott.beverley; 09-24-2015 at 06:19 PM.
(How to) Attach a Workbook
(please do not post pictures or links to worksheets)
- Click Advanced (next to quick post),
- Scroll down until you see "Manage Attachments",
- Click that then select "add files" (top right corner).
- Click "Select Files" find your file, click "open" click "upload"
- Once the upload is completed the file name will appear below the input boxes in this window.
- Click "Done" at bottom right to close the Attachment Manager.
- Click "Submit Reply"
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks