Forum Discussion
Solved
Calculate date in a specific product list
Hi, I would need to be able to calculate a shortage date/time. Attached document represents all assembly product starts in a factory. Based on what the user/vlookup will enter in G1-G4, I would l...
For that layout
it could be
Product:
=INDEX(FILTER(C:C, C:C <> ""),XMATCH($G$2, FILTER(C:C, C:C <> "") )+$G$3+$G$4)Date:
=INDEX(A:A, XMATCH(0, C1:INDEX(C:C, XMATCH( G7,C:C))+0,0,-1) )
Exactly as you said
=INDEX(
FILTER( Sheet1!C:C, Sheet1!C:C <> ""),
XMATCH( $G$2,
FILTER(Sheet1!C:C, Sheet1!C:C <> "")
) + $G$3+$G$4
)and
=INDEX(
Sheet1!A:A,
XMATCH( 0,
Sheet1!C1:INDEX( Sheet1!C:C, XMATCH( G7, Sheet1!C:C))+0,
0,
-1)
)Please check in second sheet attached.
The only I'd do not use entire columns in formulas - better named ranges, dynamic ranges or simple range with some gap for future expansion.
Thank you for your help. Do you have any solution for:
How do I calculate the number of productstart that day? So if the product number is the 3rd start in the list 2021-10-02, I want the function to return only '3'.
How do I calculate the number of productstart that day? So if the product number is the 3rd start in the list 2021-10-02, I want the function to return only '3'.