+ Reply to Thread
Results 1 to 5 of 5

Search for Highest

  1. #1
    Registered User
    Join Date
    04-22-2007
    Posts
    1

    Search for Highest

    first of all we cant upload an excel file

    anyways, i'm not that acquainted w/ excel and i need help with figuring out how to get the "Points Behind Leader" column to work. inotherwords, i want to be able to have excel subtract the points of the team w/ highest score from all other teams.
    Attached Images Attached Images

  2. #2
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,205
    In J2 put

    =F2-MAX($F$2:$F$10)

    and fill down to J10

  3. #3
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Please Login or Register  to view this content.
    Just in case you need to do it again in the future, this is how to do it.

    Go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this to your post.
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  4. #4
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    Shouldn't that be the other way round?

    If you want the points behind the leader then you need to subtract each teams score from the highest score, which would be this formula in J2 copied down.

    =MAX(H$2:H$10)-H2

  5. #5
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,205
    Yep, my formula will return non-positive values. Good eye.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1