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





Got a Question? Ask it Here in the Forum.