Increase cells by 1 but exclude hidden ones

[Clouds]

I have a list of overall results. Within that list I have different classes that I filter via an "Auto Filter"

If I currently filter that list, the person that came say 5th overall might have won another class. It currently shows that person's position as number "5", but I would like it to show "1", the second person in that class as "2" etc etc.

Is there a formula that I can put into the cells that will increase by 1, but exclude the hidden cells above it when the classes are filtered.

 

[HalfAce]

Sorry Clouds, but (if I understand your question) the answer is no.
Formulas will update (even in filtered rows) whether their columns are hidden or not.

(And, welcome to the board!)

 

[Clouds]

(And, welcome to the board!)

Thanks HalfAce - been lurking for quiet a while here. Its the first place I look for answers.

 

[HalfAce]

been lurking for quiet a while

Well, nice to see you finally come aboard then.
(It's a drag the answer to your first question was 'no'.)

 

[Weaver]

Clouds,

Are you sorting the filtered results or using the RANK() function?

 

[Clouds]

Weaver - I am filtering using an Auto Filter.

I figured it out. I thought that somehow the Subtotal function could help me and spent a while trying each "Function_num". Once I had the formula doing the correct calculation, it was a simple matter of hiding it for the blank cells. I ended up with the formula below in my A column and the C column is the persons name. (This is the formula out of cell A21)

<TABLE style="WIDTH: 415pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=553 x:str><COLGROUP><COL style="WIDTH: 415pt; mso-width-source: userset; mso-width-alt: 20224" width=553><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8 0.5pt; BACKGROUND-COLOR: transparent; WIDTH: 415pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8 0.5pt; BORDER-RIGHT: #ece9d8 0.5pt" class=xl65 height=17 width=553 x:str="'=IF(C21="","",(SUBTOTAL(3, $C$10:C21)))">=IF(C21="","",(SUBTOTAL(3, $C$10:C21)))



</TD></TR></TBODY></TABLE>