Excel Magic Trick 1272

DESCRIPTION

Max Value for Each Day Of The Week: AGGREGATE Function (2 Methods)
Learn how to find the max value for each day of the week using the Excel 2010 or later function AGGREGATE. See two situations: 1) Criteria is Mon, Tue, Wed and so on, and 2) Criteria is 1, 2, 3 and so on.
(00:12) Problem Setup
(01:29) Criteria is 1, 2, 3 and so on: Use AGGREGATE and WEEKDAY function
(05:23) Criteria is Mon, Tue, Wed and so on: Use AGGREGATE and TEXT function

WORKBOOKS




Be the first to comment

Leave a Reply