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) )
Please describe in more detail what your plans are.
Welcome to your Excel discussion space!
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
NikolinoDE Hi,
G2 = 111112
This is the product I want to start the calculation from. Then calculate 7+5 (G3 + G4 number of steps) down the list and return the new product number, date and number of productstart of that day.
G columns are where the user will enter the data.
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) )Wonderful, that works. Just had to change all the ',' to ';'
The list is in another excel sheet. How do I change the path from C:C to Sheet1!C:C ?
