Results 1 to 11 of 11

Can you use MAX function on numbers/text?

Threaded View

  1. #1
    Registered User
    Join Date
    12-17-2009
    Location
    Baghdad, Iraq
    MS-Off Ver
    Excel 2003
    Posts
    13

    Can you use MAX function on numbers/text?

    I am trying to use the "MAX" function to find the max temp on a particular day in a week from 7 separate sheets. The problem I have is one particular company autopopulates their temperature block with the temp and degree symbol: 46°F instead of just 46. The max function is thrown off it appears by the symbol and letter. Is there a way to get the max function to only look at the numbers? I'm also open to the option of autoconverting each temp to a number on the master sheet and letting the "MAX" function search through those if that's possible. Thanks in advance.
    Last edited by Ogbuehi; 12-22-2009 at 04:38 AM.

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