Continuous rank

**markos97** · 08-22-2012, 09:17 AM

Hi,
I have sorted values in columns, for example in columns A:AR, and I want to generate a rank for values in each column, now I have a formula

Please Login or Register  to view this content.

, but work very, very, very slowly...

Maybe see the attach (in AT1:AT23, I have a formula, but I want to put the results from AT1 to AT2604, and in this way, each column).

**daddylonglegs** · 08-22-2012, 09:28 AM

With sorted data you can use a simpler formula, in AT1 put a 1 and then use this formula in AT2 copied down

=(A1<>A2)+AT1

**markos97** · 08-22-2012, 09:37 AM

yeah, that's it!

thanks a lot daddylonglegs

very simply and fast

pretty good

**Cutter** · 08-22-2012, 12:13 PM

@ markos97

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.