Count from one .

Hello all ,

I am wanting to get the results I have in col M . A macro would be great . But willing to start with a function .

These results look at col L and sees how many times a number appears
and counts down col from one until a different number appears then count starts again .

This is all very random .

There may be up to 20 or more of each number , then next could on be one only .

Thanks .

In M2, copied down:

Please Login or Register  to view this content.

It looks like the goal is to simply count how many consecutive times n appears in Tab#. You also seem to prefer a macro, but I wonder why. Here's how I would do it with a simple worksheet formula:
In M2 enter 1
In M3 enter =IF(L3=L2,M2+1,1) and copy down as far as needed.

If I decided that I really preferred VBA, then it would be the same thing but in a VBA loop. (pseudocode)

Please Login or Register  to view this content.

Personally I prefer the spreadsheet function programming language for something like this, but the VBA language works fine, too.

Thanks to you both , functions great . A macro is quicker on larger sheets and i dont have to send to values etc , less work as such .
But what is provided works perfect . Thanks again .

Thanks Rick , can also use this . Thank you .