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 w...
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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.