Results 1 to 5 of 5

Thread: Finding the Max

  1. #1
    Join Date
    Apr 2007
    Location
    Stalybridge, Manchester
    Posts
    273

    Unanswered: Finding the Max

    Not sure if I'm having one of those days already but, I want to find out to show the Max number between a set of different cells.

    I have a report which show different information. I want to take certain cells and find out what the max number would be...

    An example of where they are set out is

    C12
    F12
    I12
    C24
    F24
    C36
    F36

    I thought =MAX(C12,F12 and so on would work but I end up with error

    Where I gone wrong?

  2. #2
    Join Date
    Jun 2004
    Location
    Haaksbergen, Netherlands
    Posts
    69
    I think the format should be =MAX(C12;F12...

    So swap the comma for a semicolon...

  3. #3
    Join Date
    Apr 2007
    Location
    Stalybridge, Manchester
    Posts
    273
    I have the problem where that these numbers are imported via code from SQL Server. They are showing as Text when being imported, how can they be changed to number?

  4. #4
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    The operator for joining arguments in Excel is the comma.

    If your values are coming through as text, use the VALUE() function to turn them back into digits. (What I tend to do in this situation is mark then end of the column next to the data range, and then create a formula at the top to do what I need. In this case, it would be =VALUE([CellReference]). Then I copy that formula down to the mark, copy the formula range and paste values over the source column.)

  5. #5
    Join Date
    Oct 2003
    Posts
    1,091
    Either that, or multiply every cell by 1, which converts them to numbers.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •