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
Leave a Reply
|Free Invoice Template using Excel – Download||Why you should close down Excel completely|