+ Reply to Thread
Results 1 to 2 of 2

Multiple modes that are text and not numbers

  1. #1
    Registered User
    Join Date
    11-15-2024
    Location
    Atlanta, GA
    MS-Off Ver
    Sheets
    Posts
    1

    Multiple modes that are text and not numbers

    I am trying to make a spreadsheet for NFL quarterback. There are two columns that I need this formula for. They are the team and opponent columns. I want a formula that will show me the most common team in each column. The problem I have though is when there are multiple teams that appear the same amount of times in one column. I cant find a formula to show both the teams. What I have now just whos one of them even if there is a tie. I would honestly be fine with something that says "error" or whatever, but it doesn't work for me if only one team shows when there are multiple tied.
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    19,043

    Re: Multiple modes that are text and not numbers

    Hello ROYGBIV_420 and Welcome to Excel Forum.
    I am not familiar with sheets.
    Would it be possible to attach an Excel copy of the file so that we can see how/if the issue could be resolved in Excel and then the resolution could be translated into sheets?
    Information as to attaching an Excel file to your next post is given in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page.
    Please manually include the results you would like to see produced.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 04-23-2020, 07:39 AM
  2. How to program my macro to choose between multiple modes and no modes
    By joeywalsh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2017, 04:51 PM
  3. Finding Multiple Text String Modes from a single range
    By liquidmettle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-16-2015, 02:28 PM
  4. sumifs with mulitple columns and mulitple criteria in each column
    By bkaufman in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 07-18-2012, 05:11 PM
  5. [SOLVED] switching between modes
    By Joe in forum Excel General
    Replies: 3
    Last Post: 02-09-2006, 10:00 AM
  6. switching between modes
    By Joe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2006, 12:00 PM
  7. [SOLVED] What is the formula for adding mulitple numbers in one excel cell.
    By Merlin_au in forum Excel General
    Replies: 1
    Last Post: 01-04-2005, 07:06 AM

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