Excel Magic Trick 1198


Median for Each Quarter Using AGGREGATE Function

DESCRIPTION

See how to calculate Median for Each Quarter Using AGGREGATE Function
(00:08) Problem Setup
(00:49) Defined Names for ranges using keyboard for Create Names From Selection: Ctrl + Shift + F3
(01:54) Apply Names in Formula
(02:14) Create Upper and Lower Dates Limits for each quarter
(02:23) EOMONTH function to get End of Each Quarter
(03:19) AGGREGATE function to calculate Median with two criteria: Lower Date and Upper Date fo5 each Quarter. Using Function 17: Quartile.INC and a Boolean AND Logical Test (AND Criteria) using Multiplication.

WORKBOOKS




Be the first to comment

Leave a Reply