Results 1 to 15 of 15

Get Max Value from a list of scores within a single cell

Threaded View

  1. #1
    Registered User
    Join Date
    01-07-2008
    Location
    Northampton, UK
    MS-Off Ver
    version 2212, office 365 enterprise
    Posts
    74

    Question Get Max Value from a list of scores within a single cell

    I've tried searching online and on this forum and can't seem to find a formula that works

    I have text within a single cell in the following format:

    Score A [1]
    Score B [2]
    Score C [7]
    It has multiple text lines within a cell with a number in square brackets. I want the cell next to this one to return the maximum score from that string of text.

    Is there a formula that will work for this?

    Here is an example sheet, scores are in cell E7 and I want to return the max in E8

    forum example.xlsx
    Last edited by chrismann85; 01-25-2023 at 10:06 AM.
    Ne auderis delere orbem rigidum meum!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. List Top 5 Scores and Identifying Them
    By Apokolipse in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-31-2022, 01:41 PM
  2. [SOLVED] Top Ten Scores in separate list
    By John Henworth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2021, 06:59 AM
  3. Need to enter test scores and return suggestions based on those scores
    By deborahlane in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 10
    Last Post: 09-28-2020, 01:23 PM
  4. [SOLVED] I need a macro to select range of scores, choose the best scores and apply a formula
    By hadleedog in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-12-2015, 03:15 PM
  5. Replies: 8
    Last Post: 12-20-2014, 04:37 PM
  6. [SOLVED] separate list of names in same cell separated by semicolon into one single list
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2014, 11:18 AM
  7. [SOLVED] List the most recent five scores from among multiple scores
    By Winship in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-11-2012, 09:25 PM

Tags for this Thread

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