Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Norwich, Connecticut, USA
    Posts
    150
    Thanks
    14
    Thanked 0 Times in 0 Posts

    Need Help Writing Formula (Excel 2000)

    I need help writing an Excel formula.
    (1) Cells D11146 list numbers that are in ascending order.
    (2) Cells G11:G145 also list numbers, but not sorted in any particular order.
    (3) I need a formula that for MAX(D11146), with D146 = MAX, will give me the number in cell G145 (NOT in cell G146, which is blank). Thanks. Robert

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

    Re: Need Help Writing Formula (Excel 2000)

    Sorry, I don't understand. What exactly do you want to accomplish? Your description leads to the formula =G145, but I'm sure that's not what you meant.

  3. #3
    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: Need Help Writing Formula (Excel 2000)

    If you want in cell G146 the value that is in Col G in the same row as the max value from D11145, you could use this formula in G146:
    <pre>=INDEX(G11:G145,MATCH(MAX(D11146),D11145,0))</pre>


    If that is not what you are after, could you elaborate?

    Steve

  4. #4
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Norwich, Connecticut, USA
    Posts
    150
    Thanks
    14
    Thanked 0 Times in 0 Posts

    Re: Need Help Writing Formula (Excel 2000)

    Thanks for the replies. Steve's formula is exactly what I needed! I suspected that it would have something to do with the INDEX function, but I have never been able to figure out how to use that function (even using the wizard). Now that I have an example to follow, I can now correct some other formulas that weren't working as well.

    Thanks again. Robert

Posting Permissions

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