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

Last edited: