![]() |
|
#3
|
|||
|
|||
|
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))) |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Concatenating in an Array formula
|
Phil H | Excel | 6 | 02-25-2019 08:36 AM |
| Array formula value not available error for one result | emarkona | Excel | 1 | 03-08-2018 03:00 PM |
| Array Formula | Macacidic | Excel | 2 | 09-12-2017 08:19 AM |
Excel simplify formula - array of sequential numbers
|
Wries | Excel Programming | 1 | 05-12-2014 08:32 AM |
Complex array formula
|
andrei | Excel | 9 | 02-03-2012 03:40 AM |