Results 1 to 6 of 6

Formula for finding the average of a range (two numbers separated by a hyphen)

Threaded View

  1. 08-29-2019, 11:58 PM #3
    tukae
    tukae is offline
    Registered User
    Join Date
    12-03-2007
    Location
    Singapore
    MS-Off Ver
    Professional Plus 2010
    Posts
    45

    Re: Formula for finding the average of a range (two numbers separated by a hyphen)

    Quote Originally Posted by Rick Rothstein View Post
    Give this formula a try...

    =AVERAGE(LEFT(A1,FIND("-",A1)-1),MID(A1,FIND("-",A1)+1,99))
    That worked. Thanks. The number formatting for A1 was "general". Also, for the range, you must use "-" Hyphen-Minus (character code: 002D), not "—" Em Dash (2014), or "–" En Dash (2013).
    Last edited by tukae; 08-30-2019 at 12:33 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] AVERAGE of comma separated numbers in a single cell
    By EchoPassenger in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-25-2017, 09:42 AM
  2. How Can I Add Numbers Separated by a Hyphen?
    By pikedrop in forum Excel General
    Replies: 20
    Last Post: 08-25-2017, 03:00 AM
  3. Splitting hyphen-separated data into multiple cells
    By kilowhat in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-14-2014, 10:20 PM
  4. [SOLVED] Merging two columuns into one, but having it separated by a hyphen
    By brlcarol99 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-08-2014, 12:20 PM
  5. [SOLVED] Custom Formatting of nos. separated by hyphen
    By naira in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-27-2013, 10:56 PM
  6. [SOLVED] Can you take 2 separate time fields and combine the two separated by a Hyphen in a third?
    By airplanesmoke in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2013, 09:59 AM
  7. [SOLVED] many numbers in one cell separated by hyphen.
    By baju in forum Excel General
    Replies: 7
    Last Post: 02-09-2005, 11: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1