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







Related Articles

Excel Is Fun

Office 2016 01

DESCRIPTION Topics in this video: (00:01) Introduction (00:28) Programs/Apps (application software) (02:32) Task Bar (02:56) Operating Systems (03:11) Start Button (05:23) USB Flash Drive (05:58) Introduction to Windows Explorer (09:34) Deleting a File or Folder [Read More >>>]

Excel Is Fun

Excel Magic Trick 1321

DESCRIPTION See how to use (00:14) Intro (01:36) MIN & MAX & IF & SEARCH solution (Any Version of Excel) (07:49) INDEX & MATCH & LEFT solution (Any Version of Excel) (08:35) AGGREGATE & ISNUMBER [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 41

DESCRIPTION Topics in this video: 1. What do Charts do? Visually portray Quantitative data (number data). Give a quick impression of the number data. Create a picture that can communicate more quickly than just the [Read More >>>]

Be the first to comment

Leave a Reply