Spreadsheet: 858334d1707059135-spilled-array-formula-spill-array-formula-01
Sheet: WIP

 | ID | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z |  |  |  | column | range |  | Pivot |  | Expected Result (Spill Array) |  |  | HansDouwe |  |  | ExceLogan
 | 1 | 18 | 2 | 2 | 3 | 0 | 2 | 1 | 2 | 1 | 3 | 1 | 2 | 1 | 3 | 26 | 2 | 0 | 22 | 0 | 22 | 2 | 32 | 2 | 4 | 2 | 2 |  |  |  | g,i | 4 |  |  |  |  | 0,2 |  |  |  |  |  | 0, 1
 | 2 | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 2 | 1 | 4 | 24 | 0 | 0 | 2 | 0 | 2 | 1 | 3 | 2 | 5 | 0 | 0 |  |  |  | h,i | 4 |  |  |  | g,i | 0,1 |  |  |  |  | g,i | 0, 2
 | 3 | 13 | 2 | 2 | 222 | 0 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 24 | 0 | 2 | 2 | 0 | 2 | 1 | 3 | 1 | 5 | 0 | 2 |  |  |  | d,e,f | 1 |  |  |  | h,i | 2,2 |  |  |  |  | h,i | 0, 1
 | 4 | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 0 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0 |  |  |  | d,e,g | 1 |  |  |  | h,i | 3,2 |  |  |  |  | h,i | 2, 2
 | 5 | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 2 | 1 | 22 | 1 | 4 | 2 | 0 |  |  |  | d,e,h | 7 | If I change any value from range to 0 then both formula is giving error result |  |  | h,i | 0,1 |  |  |  |  | h,i | 3, 2
 | 6 | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 20 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0 |  |  |  | d,g,h | 1 |  |  |  | d,e,f | 0,0,0 |  |  |  |  | d,e,f | 0, 0, 0
 | 7 | 15 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 2 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0 |  |  |  | d,g,i | 1 |  |  |  | d,e,g | 0,0,0 |  |  |  |  | d,e,g | 0, 0, 0
 | 8 | 18 | 7 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0 |  |  |  | d,e,g,i | 30 |  |  |  | d,e,h | 0,0,2 |  |  |  |  | d,e,h | 22, 0, 2
 | 9 | 8 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 24 | 0 | 0 | 2 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 2 |  |  |  | e,f,g | 3 |  |  |  | d,e,h | 0,0,3 |  |  |  |  | d,e,h | 222, 0, 2
 | 10 | 14 | 2 | 2 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 12 | 0 | 2 | 22 | 0 | 2 | 1 | 22 | 2 | 3 | 0 | 2 |  |  |  | e,f,h | 3 |  |  |  | d,e,h | 0,0,0 |  |  |  |  | d,e,h | 3, 0, 0
 | 11 | 14 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 4 | 0 | 22 |  |  |  | e,f,i | 3 |  |  |  | d,e,h | 3,0,0 |  |  |  |  | d,e,h | 0, 0, 0
 | 12 | 18 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 28 | 2 | 0 | 2 | 0 | 2 | 1 | 32 | 2 | 5 | 2 | 2 |  |  |  | e,g,h | 3 |  |  |  | d,e,h | 222,0,2 |  |  |  |  | d,e,h | 0, 0, 2
 | 13 | 20 | 1 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 25 | 0 | 0 | 22 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 22 |  |  |  | e,g,i | 3 |  |  |  | d,e,h | 22,0,2 |  |  |  |  | d,e,h | 0, 0, 3
 | 14 | 24 | 2 | 2 | 222 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 15 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 22 |  |  |  | e,h,i | 3 |  |  |  | d,g,h | 0,0,2 |  |  |  |  | d,g,h | 0, 0, 2
 | 15 | 8 | 2 | 0 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 22 | 0 | 0 | 2 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 2 |  |  |  | f,g,h | 8 |  |  |  | d,g,i | 0,0,2 |  |  |  |  | d,g,i | 0, 0, 2
 | 16 | 18 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 0 |  |  |  | f,g,i | 8 |  |  |  | d,e,g,i | 0,0,0,2 |  |  |  |  | d,e,g,i | 3, 0, 1, 1
 | 17 | 22 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 0 |  |  |  | f,h,i | 8 |  |  |  | d,e,g,i | 0,0,0,1 |  |  |  |  | d,e,g,i | 2, 0, 0, 1
 | 18 | 24 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 3 | 2 | 5 | 21 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 0 |  |  |  | g,h,i | 8 |  |  |  | d,e,g,i | 3,0,1,1 |  |  |  |  | d,e,g,i | 222, 0, 1, 1
 | 19 | 22 | 2 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 16 | 2 | 2 | 22 | 0 | 0 | 0 | 22 | 1 | 3 | 2 | 0 |  |  |  | d,e,f,g | 30 |  |  |  | d,e,g,i | 222,0,2,2 |  |  |  |  | d,e,g,i | 3, 0, 0, 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,h | 25 |  |  |  | d,e,g,i | 22,0,2,2 |  |  |  |  | d,e,g,i | 22, 0, 0, 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,g,i | 22,0,1,1 |  |  |  |  | d,e,g,i | 22, 0, 1, 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,g,i | 22,0,0,1 |  |  |  |  | d,e,g,i | 22, 0, 2, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,g,i | 2,0,0,1 |  |  |  |  | d,e,g,i | 222, 0, 2, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,g,i | 3,0,0,1 |  |  |  |  | d,e,g,i | 0, 0, 0, 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,g,i | 222,0,1,1 |  |  |  |  | d,e,g,i | 0, 0, 0, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e,f,g | 0,0,0 |  |  |  |  | e,f,g | 0, 0, 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e,f,h | 0,0,2 |  |  |  |  | e,f,h | 0, 0, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e,f,h | 0,0,3 |  |  |  |  | e,f,h | 0, 0, 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e,f,i | 0,0,2 |  |  |  |  | e,f,i | 0, 0, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e,g,h | 0,0,2 |  |  |  |  | e,g,h | 0, 0, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e,g,h | 0,0,3 |  |  |  |  | e,g,h | 0, 0, 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e,g,i | 0,0,2 |  |  |  |  | e,g,i | 0, 0, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e,h,i | 0,2,2 |  |  |  |  | e,h,i | 0, 2, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e,h,i | 0,3,2 |  |  |  |  | e,h,i | 0, 3, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f,g,h | 0,0,2 |  |  |  |  | f,g,h | 2, 1, 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f,g,h | 0,0,3 |  |  |  |  | f,g,h | 22, 2, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f,g,h | 0,0,0 |  |  |  |  | f,g,h | 0, 0, 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f,g,h | 2,1,0 |  |  |  |  | f,g,h | 0, 0, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f,g,h | 22,2,2 |  |  |  |  | f,g,h | 0, 0, 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f,g,i | 0,0,2 |  |  |  |  | f,g,i | 2, 1, 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f,g,i | 0,0,1 |  |  |  |  | f,g,i | 22, 2, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f,g,i | 2,1,1 |  |  |  |  | f,g,i | 0, 0, 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f,g,i | 22,2,2 |  |  |  |  | f,g,i | 0, 0, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f,h,i | 0,2,2 |  |  |  |  | f,h,i | 2, 0, 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f,h,i | 0,3,2 |  |  |  |  | f,h,i | 22, 2, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f,h,i | 0,0,1 |  |  |  |  | f,h,i | 0, 0, 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f,h,i | 2,0,1 |  |  |  |  | f,h,i | 0, 2, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f,h,i | 22,2,2 |  |  |  |  | f,h,i | 0, 3, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | g,h,i | 0,2,2 |  |  |  |  | g,h,i | 1, 0, 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | g,h,i | 0,3,2 |  |  |  |  | g,h,i | 2, 2, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | g,h,i | 0,0,1 |  |  |  |  | g,h,i | 0, 0, 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | g,h,i | 1,0,1 |  |  |  |  | g,h,i | 0, 2, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | g,h,i | 2,2,2 |  |  |  |  | g,h,i | 0, 3, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,g | 0,0,0,0 |  |  |  |  | d,e,f,g | 3, 0, 2, 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,g | 3,0,2,1 |  |  |  |  | d,e,f,g | 2, 0, 0, 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,g | 222,0,22,2 |  |  |  |  | d,e,f,g | 222, 0, 2, 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,g | 22,0,22,2 |  |  |  |  | d,e,f,g | 3, 0, 0, 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,g | 22,0,2,1 |  |  |  |  | d,e,f,g | 22, 0, 0, 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,g | 22,0,0,0 |  |  |  |  | d,e,f,g | 22, 0, 2, 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,g | 2,0,0,0 |  |  |  |  | d,e,f,g | 22, 0, 22, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,g | 3,0,0,0 |  |  |  |  | d,e,f,g | 222, 0, 22, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,g | 222,0,2,1 |  |  |  |  | d,e,f,g | 0, 0, 0, 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,h | 0,0,0,2 |  |  |  |  | d,e,f,h | 3, 0, 2, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,h | 0,0,0,3 |  |  |  |  | d,e,f,h | 2, 0, 0, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,h | 0,0,0,0 |  |  |  |  | d,e,f,h | 222, 0, 2, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,h | 3,0,2,0 |  |  |  |  | d,e,f,h | 3, 0, 0, 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,h | 222,0,22,2 |  |  |  |  | d,e,f,h | 2, 0, 0, 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,h | 22,0,22,2 |  |  |  |  | d,e,f,h | 22, 0, 0, 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,h | 22,0,2,0 |  |  |  |  | d,e,f,h | 22, 0, 2, 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,h | 22,0,0,0 |  |  |  |  | d,e,f,h | 3, 0, 2, 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,h | 2,0,0,0 |  |  |  |  | d,e,f,h | 22, 0, 22, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,h | 3,0,0,0 |  |  |  |  | d,e,f,h | 222, 0, 22, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,h | 222,0,2,2 |  |  |  |  | d,e,f,h | 0, 0, 0, 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,h | 2,0,0,2 |  |  |  |  | d,e,f,h | 0, 0, 0, 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,e,f,h | 3,0,2,2 |  |  |  |  | d,e,f,h | 0, 0, 0, 3