Thanks for the reply hui.My doubt is how would this logic work for all the products as there are different dates for different products.please explain.
Thanks HUI, for the reply.but sorry,i fear i had not explained my problem clearly.
Can i send the excel sheet to you so that the problem would be clear enough for understanding.
Please tell me how to send the attachment.
hi,
i want to know the formula for displaying the months with year from the dates.I had a worksheet with columns:-
A: Products A,B,C & So on....
B: Date Sold
C: Quantity
D: Amount.
Criteria:I want to show the summary of the products sold monthly,like,
For product A; All the products A...