When writing my previous post (#2), it was over midnight for me, and I did make it too difficult.
Forget about entering any Concat numbers into 1st row of 2nd table. Design table headers as you want.
The formula you enter into B2 of 2nd table will be:
Code:
=IF(SUMIFS(nTableRow,nIndex,$A2,nConcat, COLUMN()-1)=0,"",INDEX(nConcat,SUMIFS(nTableRow,nIndex,$A2,nConcat, COLUMN()-1)))
You can keep formulas in 2nd table. Whenever you edit 1st table, when in 2nd table the value of Index is registered, and there is enough Concat columns present, the changes are available in 2nd table immediately.
03-22-2024, 05:36 AM
Similar Threads
Concatenating in an Array formula
Windows 8 
Office 2016
Hybrid Mode