Find out oldest date using multiple criteria

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Find out oldest date using multiple criteria 1

    1. Formula (0) 0%
    2. Macro (1) 100%

    Poll ends on Jan 19th 2038, 3:14 am

    I want to know the macro code to find out the oldest date in the Calculation sheet of the attachment based on two criteria.

    The criteria should be if the Item ID on Calculation sheet macthes the Item Id Pivot sheet and then if the Status on pivot sheet and calculation sheet matches then the macro should find out the oldest date for each item ID. And once the oldest date is identified the difference on pivot sheet should be added to the cost basis column on calculation sheet to the already found oldest date lot.find the attached excel sheet and try to get me the code ASAP. Thanks a lot in advance.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!