dan_l
Active Member
Weird requirement:
I've got to set up a gigantic sum product with several conditions. I'll be using the results inside an index/match formula. So my data is structured:
[dan's stupid sequential index column] [some dimension] [other dimension] [blah] [blah] [a text description of the solution]
So, the formula as it stands now is:
=sumproduct((condition=1)*(condition2=2)*(condition3=3)*index number)
So the result will be the index number, which plugs nicely into the index match. I'm trying to be lazy and not have to use the index number because there's roughly 80k rows. Is there a way I can replace the *index number with the natural row number?
I've got to set up a gigantic sum product with several conditions. I'll be using the results inside an index/match formula. So my data is structured:
[dan's stupid sequential index column] [some dimension] [other dimension] [blah] [blah] [a text description of the solution]
So, the formula as it stands now is:
=sumproduct((condition=1)*(condition2=2)*(condition3=3)*index number)
So the result will be the index number, which plugs nicely into the index match. I'm trying to be lazy and not have to use the index number because there's roughly 80k rows. Is there a way I can replace the *index number with the natural row number?