Thanks,
I guess it is a problem with formulas when you update the input data. The input range is not static. So when I import a data stream with more rows than before the formula columns does not print on the extra rows. Hmmm..
This is a discussion on Lookup a column of values with the largest sum within the Excel Questions forums, part of the Question Forums category; Originally Posted by Pille Ok checked and it works making a table with the above #3 including the empty cells. ...
Let's separate data (input) and processing (output)...
data (name of the data sheet)
Row\Col A B C D 1X1 X2 X3 X4 2 1 16 4 9 3 8 3 2 1 4 11 5 9 6 5
processing (the name of the processing sheet)
Row\Col A 1 2 2X2 3 16 4 3 5 5 6
In A1 of processing control+shift+enter, not just enter:
=MATCH(MAX(MMULT(TRANSPOSE(data!A2:D4),ROW(data!A2:D4)^0)),MMULT(TRANSPOSE(data!A2:D4),ROW(data!A2:D4)^0),0)
In A2 of processing just enter:
=INDEX(data!A1:D1,A1)
In A3 of processing just enter and copy down:
=IFERROR(INDEX(data!$A$2:$D$4,ROWS($A$3:A3),$A$1),"")
If you get the problem when you do a new import, we can implement dynamic named ranges in order not to miss any change to the data area in the data sheet if you like...
Assuming too much and qualifying too much are two faces of the same problem.
Thanks,
I guess it is a problem with formulas when you update the input data. The input range is not static. So when I import a data stream with more rows than before the formula columns does not print on the extra rows. Hmmm..
Assuming too much and qualifying too much are two faces of the same problem.
Ok I get it. My ranges are from 500 to maybe 20 000 rows. Source is csv through query, works fine.
The one I build with is 1500 rows.
Kind Regards
Per
Ok,
It's A2:I1098
/Per
Column B and C is text. But I can live without them if necessary. They only tell me what I'm working with. They are all equally filled, always.
/Per
Assuming too much and qualifying too much are two faces of the same problem.
No, A is just counting rows.
/Per
Like this thread? Share it with others