Adding smallest value + second smallest value until exceeding a specific value

[ployo60]

Hello,

I have been trying to create 'do while' loop to create a counting mechanism for the smallest number and then the second smallest number.

What I would like to do is take the smallest value from A2 down till the bottom filled row and then find the smallest number, add that to the second smallest, add that to the third smallest, etc. until I go over a specifically set value. Just call that maximum. What I finally need is the number (n) that smallest number has been counting.
Example if my numbers were: and maximum is <=10:

1
4
7
9
2
3
5


1+2+3+4...... then n=4.

How can I write this in VBA?

[jindon]

..........

[jindon]

Something like this

Please Login or Register  to view this content.