![]() Let’s look at each component of the formula starting with IF: It’s an array formula so it’s entered with CTRL+SHIFT+ENTER, which automatically inserts the curly braces you can see surrounding the formula in the formula bar above. The formula is: = IFERROR( MEDIAN( IF(Table1=Pivots!B8,Table1) ) ,"") I’ve formatted the header in cell D7 with blue fill to make it appear part of the PivotTable, but you if you look in the formula bar you'll see the formula: In the image below you can see my PivotTable is in columns B and C, and I’ve put my median formula in column D. ![]() It’s not actually ‘in’ the PivotTable, but rather in a spare column to the right of your PivotTable. We’ll look at calculating the Median in a regular PivotTable first. ![]() xlsx files, please ensure your browser doesn't change the file extension on download. Excel for Decision Making Under Uncertainty Course.Excel for Customer Service Professionals.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |