Title:
Excel Magic Trick 455: Advanced Filter Macro: Extract Grant Records Under A Cumulative Total
Video:
Description: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
Published:
01/Dec/2009
Excel Magic Trick 455: Advanced Filter Macro: Extract Grant Records Under A Cumulative Total
Video:
Description: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
Published:
01/Dec/2009
No comments:
Post a Comment