finding the minimum value in a row of numbers
Prep for a pre-employment Excel test with Job Test Prep
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,445
    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,305
    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,305
    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,305
    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

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
  •  

 

 
DMCA.com