Do.. While.. Counting cells less than

[magni]

Hi All

I'm a VBA novice, I don't really know much VBA but I really need your help..

I have a list of numbers and I have to count until there is a number bigger than the number the loop is currently in and I have to do this for every cell in the range.

For instance:

A B
10 = 1
9
12

So 12 is bigger than 10, so there was only one cell less than 10 before a bigger one appeared, the B1 Cell now equals to this count.

How can I do this?

Best,
Magni.

[TonyS]

Hi,
Try this

Please Login or Register  to view this content.

Tony