|
Featured Tutorial
Featured Macro
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
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