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
    Location
    The Hague, NL
    Posts
    81,807
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

     
    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.

    Thanks
    John
    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.

    Aladin

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

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

    Default

      
    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

    John

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
  •  

 

 
DMCA.com