Forum Discussion
Excel division
Hi, I would like to be assisted with a formula that can calculate as per below; 1. Check the Quantity ordered for a given variety and then divide this amount by the maximum pack rat...
A_SIRAT , till that time, did you note the formulas based solution i posted? It is not as elegant as Power Query, but could help you for the time being, perhaps!
The formulae is noted though power query as demonstrated by Detlef_Lewin is really powerful. I just add more varieties and hit the refresh button and the magic happens 🙂
I have just become more curious by checking videos on Trump excel, excel campus. If any of you has some simpler materials, please share.
Anyway appreciated and I keep both solutions for my records.
- Certainly, Power Query is a whole new dimension to Excel