Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2006
    Posts
    250
    Thanks
    0
    Thanked 0 Times in 0 Posts

    randon number (2003)

    Hello Everyone,

    I got a question regarding the attached spreadsheet. I need to create a formula in column D or VB that will give me the following information. I need to have find out if the Column A has the same number in column B to give me the highest Rank number (Column C) first and if the same number is selected in column A again, I need to give me the second ranking and so forth. For example, number 6 appears in column A multiple times. I need it go give me the highest ranking and then the second highest ranking and so forth. Any help would be great.

    Thanks.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: randon number (2003)

    Please excuse me, I don't understand your description. Could you explain what exactly you want the result to be?

  3. #3
    3 Star Lounger
    Join Date
    Dec 2006
    Posts
    250
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: randon number (2003)

    I need a formula that looks a column A and column B and uses the highest rank number in column C for the first number. Column C reflects Column B ranking. For example, if you look at the number 8 in column A you will see 2 times. In column B, 8 appears 4 times. I need a formula or macro that once it finds the first 8 it will give me the highest rank and then when it finds 8 again it gives me the second highest rank. In this case the first 8 ranking is 1 and second highest is 2. I hope this makes sense.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: randon number (2003)

    I'm sorry, I don't get it. Perhaps someone else can help.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: randon number (2003)

    I am also confused.

    If we have the numbers you have in A and B and C, what numbers do you want to see in each row of D? What is the logic for figuiring each one out?

    For example, what should the value in D3 be? How is it determined? What about D4, D5, etc?

    Steve

Posting Permissions

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