Excel Forum

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
4.Delete Columns
5.Macro Recorder
6.Advanced Filter

Got a Question? Ask it Here in the Forum.