Excel Forum
Similar Content
Prevent Saving a Workbook under a Different File Name
Macro: This Excel macro prevents the user from saving an excel file or workbook under a diffe...
Make Users Enable Macros in Order to View a Workbook in Excel
Tutorial: Tutorial showing you how to make a user enable macros in a workbook in order to view the ...
Filter Data in Excel to Display Records that Contain a Value Between Two Values - AutoFilter.
Macro: This free Excel macro filters data to display only those records or rows that contain a va...



Excel Magic Trick 455: Advanced Filter Macro: Extract Grant Records Under A Cumulative Total


See how to extract grant records with highest point value and only extract enough records collectively that are under the Total Funding Ceiling:

1.AND function for 2 criteria
2.Running Total Formula with SUM function and Range half relative and half absolute
3.Sort
4.Delete Columns
5.Macro Recorder
6.Advanced Filter





Got a Question? Ask it Here in the Forum.