Hello guys,
I am searching for a solution how to extend a table, containing array formulas, automatically upon entering a new info in external table, which my main table is relying on. The basic setup is as follows:
I have initial table, in which I enter all neccessary values, it contains two columns: Order name and date of completion. Another table summarizes the first one by searching a unique order name, using {=INDEX(A2:A30,MATCH(0,COUNTIF($A1$:A1,A2:A30),0))}( there can be a few orders with the same names, but with different dates) and, then, the closest date is found using {=MIN(IF(A2=A:A,B:B))}. However, the first table needs to be periodically updated, so the second table has to reflect the new date. But i am struggling how to make the second table to extend automatically. Are there any ideas how it can be done?
Thanks.
I am searching for a solution how to extend a table, containing array formulas, automatically upon entering a new info in external table, which my main table is relying on. The basic setup is as follows:
I have initial table, in which I enter all neccessary values, it contains two columns: Order name and date of completion. Another table summarizes the first one by searching a unique order name, using {=INDEX(A2:A30,MATCH(0,COUNTIF($A1$:A1,A2:A30),0))}( there can be a few orders with the same names, but with different dates) and, then, the closest date is found using {=MIN(IF(A2=A:A,B:B))}. However, the first table needs to be periodically updated, so the second table has to reflect the new date. But i am struggling how to make the second table to extend automatically. Are there any ideas how it can be done?
Thanks.
