Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: finding the minimum value in a row of numbers

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Need to fin the minimum value in arow of numbers

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    Use the MIN function.

    =MIN(range)

    Bye,
    Jay

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This does not work because it is in a row. It does not work in my case anyhow

  4. #4
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-16 09:35, drag-driver wrote:
    This does not work because it is in a row. It does not work in my case anyhow
    =MIN(A1:F1)

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hiya,

    Is your data simply numeric and stored in a single row (say A1:Z1 for example)? If that is true, =MIN(A1:Z1) should output the minimum value in that range. Is your data not completely numeric but has some order type (blah1,blah2,blahh3 for example)?

    feel free to kick out a sample data set,
    Adam

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


  7. #7
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Its not recognising my numbers properly because they were numbers which i cocatenated. Even changing the format to number wont work it kepts returning the value 0 as the minvalue.

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey again,

    You may want to tweak your concatenation formula a little. Instead of =A5&B5 (simplified example) use =(A5&B5)+0 -> this will autoformat the cell as a number.

    You could also do the: Copy a 0, highlight range, editpaste specialadd to convert to a number - then MIN will work.

    Adam

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Oh, you could also use an array formula I suppose if you need the concatenated version (say for formatting purposes):

    ={MIN(A1:Z1+0)}

    hit Ctrl+Shift+Enter to get the brackets

    Adam

  10. #10
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Works great thanks for the help

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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