gillani77
New member
- Joined
- Jun 18, 2014
- Messages
- 17
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- office2013
Hi ,
I want to show trend of each customer ( going upward or downward).
1. I have number of orders placed in month of Jan by each customer in column "B"
2. I have number of orders placed by same customer in month of Jun in column "L"
I want to analyse following in column "N".
1. If customer has made more orders in Jun that jan then his trend is upward and it should be shown with upward arrow
Or
2. If customer has made less orders in Jun that jan then his trend is downward and it should be shown with downward arrow
Can some body help me in making this report. I have attached my sheet for your consideration pls.
I want to show trend of each customer ( going upward or downward).
1. I have number of orders placed in month of Jan by each customer in column "B"
2. I have number of orders placed by same customer in month of Jun in column "L"
I want to analyse following in column "N".
1. If customer has made more orders in Jun that jan then his trend is upward and it should be shown with upward arrow
Or
2. If customer has made less orders in Jun that jan then his trend is downward and it should be shown with downward arrow
Can some body help me in making this report. I have attached my sheet for your consideration pls.