Main Profile

At A Glance

Excel Magic Trick 936: Extract Employee Names For Max Value on Given Date Period (Including Dups)

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htmThis video is part 2 to video: Excel Magic Trick 935: MAX Value Between Two Dates: DMAX, MAX-IF-IF, or AGGREGATE Function? This video is part 2. For part 1 see: Excel Magic Trick 935.See how to create array formula to extract all the employee names (Duplicates may exist) who had max value for a given date period using formulas for Excel 2010, Excel 2007 and Excel 2003.Extract Multiple records and display values horizontally when there are three criteria and there may be duplicate records that may match the three criteria using these formulas:1) See the Excel 2010 solution with functions IFERROR, INDEX, AGGREGATE, ROW, COLUMNS2) See the Excel 2007 solution with functions INDEX, SMALL, IF, ROW, COLUMNS3) See the Excel 2003 solution with functions INDEX, SMALL, IF, ROW, COLUMNS
Length: 08:19

Contact

Questions about Excel Magic Trick 936: Extract Employee Names For Max Value on Given Date Period (Including Dups)

Want more info about Excel Magic Trick 936: Extract Employee Names For Max Value on Given Date Period (Including Dups)? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question