Sunday, October 25, 2009

Complicated Nested IF Loop (MS EXCEL).

My Friend asked me a Question and for him I have made this template. In this template I have try to describe using of Nested loop.
The scenario is that we have different shops in our company and we want to see in which month sale has changed so our result will be that month like june on row 2
The Wokring formula is in column Q.
Download Template:

3 comments:

  1. Hi, Really great effort. Everyone must read this article. Thanks for sharing.

    ReplyDelete
  2. Awakening post to read and it creates a common sense among readers too. Thank you.

    ReplyDelete
  3. Great, Keep it up! I really like your writing skills.

    ReplyDelete