• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

First or Last date of material received

A

Ajinkya

Member
Hi Masters,


I have huge data (of last 5 years) with material received date.

There is a "XYZ" material received 100 times in a 10 days/month/year.


I want to find out what is the first or last date received of "XYZ" material ?

Is there any formula for that...?


for more understanding sample data as per follow....


Item Rec.Date Item Qty

09-06-11 P1 250

12-06-12 P1 200

19-06-12 P1 200

09-06-11 B2 400

12-06-12 B2 100

20-06-12 B2 49

01-07-11 S4 750

02-07-11 S5 250


thanks in advance.
 
Ajinkya


Have a read through Chandoo post of 2 days ago: http://chandoo.org/wp/2012/07/03/find-the-last-date-of-an-activity/


That should point you in the right direction
 
Thanks Hui,Its really helped me.

could you pls guide me how come we can find out first date instead of last.
 
You must log in or register to reply here.
Back
Top