Rank macro has stopped working after 10 years .

[I need excel help]

Hello all ,

I have this macro which for years has always worked non stop for me . Run smily face button .

It is supposed to look at col F and see per race number how many pieces
of data it is to rank in col H from lowest to highest number .

Examples race,s 1 and 2 have 9 in field .

"I am getting funny stuff like these . =RANK(RC[1],R2C8:R10C8,1)
"
I have not changed anything and am stumped as to why its not ranking each race .

This works over 470,000 rows and is 100% accurate .

Looking for advise please .

Thanks .

[6StringJazzer]

Column G is formatted as "Text". When VBA writes a formula to a cell that is formatted as "Text" you see the formula instead of the result of the formula.

There is no smiley face button in your file, but I ran the macro directly. Reformat the entire column to be General, delete the formulas, and run your macro.

[I need excel help]

Hello Jeff ,

Thanks for that , i clearly made a boo boo at some point .

I'm happy that's all it was .

Thanks again .

[6StringJazzer]

Glad to help, thanks for the rep!