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