Hello friends,
There is one column, eight numbers in column A, find which row in the last number that complements the amount of 29
There is a formula must know a lot of friends, like this,
=MMULT(N(ROW(A1:A8)>=TRANSPOSE(ROW(A1:A8))),A1:A8).
You are invited to give a different formula,
The rule only, without volatile functions.
Next Thursday I will present my formula.
Good luck !
David
There is one column, eight numbers in column A, find which row in the last number that complements the amount of 29
There is a formula must know a lot of friends, like this,
=MMULT(N(ROW(A1:A8)>=TRANSPOSE(ROW(A1:A8))),A1:A8).
You are invited to give a different formula,
The rule only, without volatile functions.
Next Thursday I will present my formula.
Good luck !
David
Attachments

8.5 KB Views: 52
Last edited: