View Detailed Profile
Excel 2010 Magic Trick 666: AGGREGATE Function Array Formula #1 Single Cell Array Formula

Excel 2010 Magic Trick 666: AGGREGATE Function Array Formula #1 Single Cell Array Formula

Download files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT661-671-Excel_2010_AGGREGATE_Function.xlsm ...

Excel 2010 Magic Trick 668: AGGREGATE Function Array Formula #3 Calculate 90 Percentile CPA Scores

Excel 2010 Magic Trick 668: AGGREGATE Function Array Formula #3 Calculate 90 Percentile CPA Scores

Download files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT661-671-Excel_2010_AGGREGATE_Function.xlsm ...

Excel 2010 Magic Trick 667: AGGREGATE Function Array Formula #2 Return 5 Largest Values

Excel 2010 Magic Trick 667: AGGREGATE Function Array Formula #2 Return 5 Largest Values

Download files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT661-671-Excel_2010_AGGREGATE_Function.xlsm ...

Excel 2010 Magic Trick 670: AGGREGATE Function Array Formula #4 Extract Records 1 criterion

Excel 2010 Magic Trick 670: AGGREGATE Function Array Formula #4 Extract Records 1 criterion

Download files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT661-671-Excel_2010_AGGREGATE_Function.xlsm ...

Excel 2010 Magic Trick 665: AGGREGATE function Ignores Filtered Values When Making Calculations

Excel 2010 Magic Trick 665: AGGREGATE function Ignores Filtered Values When Making Calculations

Download files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT661-671-Excel_2010_AGGREGATE_Function.xlsm ...

Excel 2010 Magic Trick 669: AGGREGATE function Can Not Handle 3-D Cell References

Excel 2010 Magic Trick 669: AGGREGATE function Can Not Handle 3-D Cell References

Download files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT661-671-Excel_2010_AGGREGATE_Function.xlsm ...

Excel 2010 Magic Trick 663: AGGREGATE function Ignores Error Values for Calculations

Excel 2010 Magic Trick 663: AGGREGATE function Ignores Error Values for Calculations

Download files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT661-671-Excel_2010_AGGREGATE_Function.xlsm ...

Excel 2010 Magic Trick 790: Formulas Convert Single Records Into Columns & Repeat Unique Identifier

Excel 2010 Magic Trick 790: Formulas Convert Single Records Into Columns & Repeat Unique Identifier

Download

Excel Magic Trick 677: AVERAGE Last 3 Scores -- Mr Excel Message Board Array Formula

Excel Magic Trick 677: AVERAGE Last 3 Scores -- Mr Excel Message Board Array Formula

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT673-682.xlsm See a great array formula from pgc01 ...

Excel Magic Trick 1325: MIN & MAX Functions For Alphanumeric / Text Values Report (8 Examples)

Excel Magic Trick 1325: MIN & MAX Functions For Alphanumeric / Text Values Report (8 Examples)

Download

Excel 2010 Magic Trick 664: AGGREGATE function Ignores Nested SUBTOTALs for Calculations

Excel 2010 Magic Trick 664: AGGREGATE function Ignores Nested SUBTOTALs for Calculations

Download files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT661-671-Excel_2010_AGGREGATE_Function.xlsm ...

Excel 2010 Magic Trick 662: AGGREGATE function Ignores Hidden Rows for Calculations

Excel 2010 Magic Trick 662: AGGREGATE function Ignores Hidden Rows for Calculations

Download files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT661-671-Excel_2010_AGGREGATE_Function.xlsm ...

Excel 2010 Magic Trick 672: AGGREGATE function Replaces SMALL Function Array Formula

Excel 2010 Magic Trick 672: AGGREGATE function Replaces SMALL Function Array Formula

Download files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT672.xlsx See how you can use the ...