Providing an Availability Date

Hi, I have a task to provide the availability date for confirming Customer Orders. I have built an initial excel table with all the Demand (Customer Sales Orders) and Supply (Purchase Orders), t...

Promised Date test file (031021).xlsx12 KB

excel

Formulas and Functions

Macros and VBA

Yea_So

Oct 04, 2021

vicarma

something like this?

The main formula is:

=INDEX(
       $C5:$H$30,
       MATCH(
             0,
             FILTER(
                    $H5:$H$30,
                    $C5:$C$30=C5
             ),
             0
       ),
       2
 )

The rest of the formula is just to format the date

cheers

Vicarma Promised Date test file (031021).xlsx13 KB

vicarma

Copper Contributor

Oct 05, 2021

Yea_So

I have uploaded an amended file, so on Sheet2 now you see the base data and next to it the pivot table I am using - with your formula in the next column after the pivot table.

I am using the pivot table to get to the "0" point.

Cheers

Yea_So

Bronze Contributor

Oct 05, 2021

vicarma

Here ya go

cheers

Forum Discussion

Providing an Availability Date

Resources