Forum Discussion
Solved
Excel Spill Row Split
I am wondering if there is away to Split the Spill that comes from the Following ARRAY. =SORT(FILTER(FILTER(TableHLP,TableHLP[District]=$A$7),{1,1,0,0,0,0,0,0}),1) It produces a list of names and s...
On each sheet you may use formulas like
=LET(k, SEQUENCE(ROWS(array)), r, IF( (k >= minN)*(k <= maxN), INDEX(array,k), "remove"), FILTER(r, r <> "remove"))
I patched startPos, i, emptyPos with IF(distinctrows=1, ...
Please check at very bottom in attached file
So I put that code in and this is what its doing.
Page 1.
Name Amount Rate Service Total Name Total
Tom Davidson .Main Introduction 12 $167.00 $2,004.00
Tom Davidson .Main Introduction 12 $167.00 $2,004.00
Introduction To Hello World 90 $109.00 $163.50
I attached the example also. Im not sure why its doing this.