Results 1 to 3 of 3

Thread: have to find largest of all values and display the corresponding item

  1. #1

    have to find largest of all values and display the corresponding item



    Register for a FREE account, and/
    or Log in to avoid these ads!

    item I II III
    i 2 j a 1 1 2 3
    i 2 j a 2 13 11 6
    i 2 j a 3 17 14 5
    i 2 j a 4 10 5 12
    i 2 j a 5 4 18 9
    i 2 j a 6 7 8 19 for1 for2 for3

    have to find largest of all values and display the corresponding item
    eg
    (formula)forI
    17 is largest so it should display a3(last 2 letters of the item)
    (formula)for2
    18 is largest so it should display a5
    (formula)for3
    19 is largest so it should display a6




    Please help me ASAP
    Zohar Batterywala
    zoharsb at gmail dot com

  2. #2

  3. #3
    Acolyte Mike_Alex's Avatar
    Join Date
    Jun 2014
    Location
    Middle Wisconsin
    Posts
    57
    Articles
    0
    Not real sure of what you are asking, but if you are looking for the largest value, you can use the LARGE, MAX or RANK formulas. Mix that with an if else statement and it would work.

Posting Permissions

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