Skip to Content
author's profile photo Former Member
Former Member

Max date in month, year etc.

Hi everyone. I have problem which I can't solve by myself and need your help.

I have table like

goods name purchase year purchase year purchase year purchase year

2014 2014 2015 2015

purchase month purchase month purchase month purchase month

5 7 2 9

exf1500 15 18

fdy1560 14

ecz7800 10 12



I would like to pick up latest data for each item. For example exf1500 is 18, fdy1560 is 14, and ecz7800 is 12.


I have tried max function which turned no result.


I really appreciate any assistance.


Best Regards.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Dec 09, 2015 at 03:03 PM

    Hello,

    Try this formula =Max([Qty]) In ([Goods Name]) and let me know if it works.


    Thanks,
    Mahboob Mohammed

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.