Results 1 to 3 of 3

Thread: ranking bug

  1. #1
    Join Date
    May 2006
    Posts
    65

    Unanswered: ranking bug

    Hi all,

    ive come accross a problem in excel where i try an copy a ranking formula over a whole set of figures:

    What i want is the formula to copy down properly like this:

    rank(S606,S606762,1)
    RANK(S607,S606762,1)
    on so on....

    what im getting is this:
    rank(S606,S606762,1)
    RANK(S607,S607763,1)
    RANK(S608,S608764,1)

    this isn't right- any way i can copy the formula properly or do i need to write it out 400 times?

    greg

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Put the dollar sign before the 762, that will freeze the last item.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    May 2006
    Posts
    65
    of course!!! how very stupid of me, should have known that

    cheers

    greg

Posting Permissions

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