Median Value in Excel Pivot Table

[@mostapha9360]

straight subscribe to you channel, your video is to the point, no BS, such an engineer lol

[@jessicak373]

Hi! Thank you so much for the clear and useful video! I'm trying to adapt your example to my current situation, but running into issues. I have two conditions: Year and Quarter. So basically, I want the formula to feed the matching number of days (in your example: Hrs/Part #) to the median function. AND I'd like it to ignore blank cells. How would I go about doing that? Thank you in advance!

[@ChicagoDispatcher]

I was looking for a way to do this using calculated fields. Is it possible?

[@TheEngineeringToolboxChannel]

No unfortunately it’s not possible with calculated fields.

[@lowqchannel]

how to do if there's many variables. is there a quick way

[@kuldeepsinghtanwar5842]

Hey.... I am a huge fan of yours 🙂 I have multiple tables with 2 columns named ENTERING and EXITING with multiple rows of start and end dates in it. What I want is to find out a common date range that falls in all tables. Can you please help ?

[@TheEngineeringToolboxChannel]

Hi Kuldeep, Thank you! I am glad you like my channel. I am not sure exactly what you are trying to accomplish, but I would love to help. Can you explain more? Feel free to email me about this as well.. [e-mail]

[@kuldeepsinghtanwar5842]

@@TheEngineeringToolboxChannel thank you so much.... I have mailed you the file

[@VoteLaborOut]

Thanks

[@fadwasaud2001]

thx but the music is noisy

[@reidmorin7984]

First here

[@ChuckDiesel15122]

This is explained horribly

[@TheEngineeringToolboxChannel]

I agree…sometimes when amateur content creators make videos in their spare time to share free information with the world, the quality isn’t the greatest. Anything specifically I should do different? Thank you for watching!