Results 1 to 5 of 5

Continuous rank

Threaded View

  1. #1
    Registered User
    Join Date
    06-28-2010
    Location
    Posen, Poland
    MS-Off Ver
    Excel 2000
    Posts
    46

    Continuous rank

    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
    =SUMA(1/(JEŻELI(A$1:A$2604<A1;LICZ.JEŻELI(A$1:A$2604;A$1:A$2604);2^99)))+1 
    
    (english version: 
    
    =SUM(1/(IF(A$1:A$2604<A1;COUNTIF(A$1:A$2604;A$1:A$2604);2^99)))+1)
    , 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).
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1