View Single Post
 
Old 03-22-2024, 05:36 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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.
Reply With Quote