Rank Function Problem - Page 3
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Page 3 of 3 FirstFirst 123
Results 21 to 22 of 22

Thread: Rank Function Problem

  1. #21
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    The Hague, NL
    Post Thanks / Like
    12 Post(s)
    1 Thread(s)


    On 2002-03-09 15:28, JohnJay wrote:
    I saw that when I tired your code out. I think the latter one would be the best thing for a growing worksheet. I will make a small area in the depts of the sheet, say around IV65536, to store those formulas. It will make them safe from overwrites and accidents...LOL. But I would like to intialize a sheet on startup to contain the rank formula from row 1 all the way to row 65536...this way I dont need to use the fill button at all.

    John, I see your concern. However, don't please fill up up to row 65536. It will make your WB crowl. I'd suggest you start a new thread in which you ask for VBA code that copies an array formula down to the last row of data in a certain column automatically whenever the data change. I'm not sure whether that's possible -- I'd say: post, wait, and see.


    [ This Message was edited by: Aladin Akyurek on 2002-03-09 15:38 ]

  2. #22
    New Member
    Join Date
    Mar 2002
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)


    I see what you mean. Maybe I could just intialize a newly inserted row, and if any new data is entered in an existing blank row, initialize that too.

    That may be a better choice than copying formulas too the 65536 row...LOL

    I will have to sleep on it. Thanks for your help aladin. Tomorrow I will give it some more thought and let you know...Thanks again


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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