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 ?
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.. theengineeringtoolbox@gmail.com
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!
straight subscribe to you channel, your video is to the point, no BS, such an engineer lol
how to do if there's many variables. is there a quick way
thx but the music is noisy
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 ?
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.. theengineeringtoolbox@gmail.com
@@TheEngineeringToolboxChannel thank you so much.... I have mailed you the file
Thanks
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!
I was looking for a way to do this using calculated fields. Is it possible?
No unfortunately it’s not possible with calculated fields.
First here