Results 1 to 5 of 5

Google Sheets: Returning value of cell on the same row as another, when using MAXIFS

Threaded View

  1. #1
    Registered User
    Join Date
    01-08-2021
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    4

    Google Sheets: Returning value of cell on the same row as another, when using MAXIFS

    Hi all!

    I'm having a competition for some kids that are competing in different groups. I'm trying to come up with an excel sheet which shows them the place that they are currently in.
    Using MAXIFS I'm able to get the correct score. When trying to put the corresponding name to this score, this will sometimes give the wrong output when there are multiple contestants with the same score. It will always pick the first row with the score found.

    Is there some way to use MAXIFS to get the value in the "Contestant" column to match the score value and group value?

    I'm using docs.google.com spreadsheet for this - not sure which version of excel that is.

    Greatful for any comments or solutions!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Google Sheets: Formatting a cell with 0.00000000
    By Jetheat in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 12
    Last Post: 05-14-2020, 02:56 PM
  2. [SOLVED] Google sheets: Function to return a value from another tab/cell
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-27-2019, 02:04 PM
  3. [SOLVED] Sending emails from a cell value via google sheets.
    By Needhelpdfec in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2019, 12:44 PM
  4. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  5. [SOLVED] Text and Today() function not returning date in right format (Google sheets)
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-10-2018, 12:01 PM
  6. Google Sheets: Background cell color changes
    By jher001 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 04-07-2018, 10:42 AM
  7. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM

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