Calculate maximum change [homework]
Today, lets see how good your formula skills are.
Calculate maximum change
Can you calculate what is the maximum change in product sales between 2 months for below data?
Bonus question: Which product is responsible for this change?
Post your answers in comments
Just post your answers comments. If you are reading this in RSS or email, then click here to post your answer.
Special note: If your formula contains < or > symbols when posting it, use < and > instead. Our commenting system eats up < and > symbols.
Want more Excel challenges?
Try this – more than 25 challenges and problems in Excel.
PS: I got inspiration for this challenge from Mike Girvin’s excellent book – Ctrl + Shift + Enter
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Free Invoice Template using Excel – Download||Why you should close down Excel completely »|