Helper column that will number visible rows

[bibu]

Hey, I hope this is easy, I am trying to display a certain number of visible rows, using AutoFilter. My idea is to use a helper column that will 'number' each visible row, but I'm not quite sure what functions to use for this.
Thanks

[TMS]

Not sure why you want to do this when the functionality is built in.

http://office.microsoft.com/en-gb/ex...001055034.aspx


Regards, TMS

[dragavs]

like this??


P3 =IF(ISBLANK(O3),P2,P2+1)
P4 =IF(ISBLANK(O4),P3,P3+1)
.
.
and so on...

[TMS]

But:

http://office.microsoft.com/en-gb/ex...001055034.aspx

[bibu]

Thanks for your answer.
Firstly, I want to be able to do that filtering (show the only the first 10, or 50, or 100 visible rows) by pressing a button, and I don't see how I can replicate that Top10 filtering via VBA (macro recorder does not record it). This must be done by autofilter and not by Entirerow.Hidden because it will not work well with other autofilters.
Secondly, from what I saw, the Top10 criteria is applied to the value of the cells, and that is not what what I need (tried to do "Top10" on the O column and nothing happened)

[bibu]

Thanks, this was about right, but it did not work if you try to autofilter (try to autofilter by Clay surface - some rows will be hidden but will not be skipped as I needed). So I tried IF(O3=0,P2,P2+1), since O3 will be = 0 if the row is hidden, and it worked
So thanks very much!