Finding lowest number in a column
Finding lowest number in a column
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Finding lowest number in a column

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I need to find and highlight the single lowest number in a column. If more than one, do nothing. Can the highlighting be done by conditional formatting?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-06 15:15, JRolph wrote:
    I need to find and highlight the single lowest number in a column. If more than one, do nothing. Can the highlighting be done by conditional formatting?
    You can use
    =AND(A1=MIN(A:A),COUNTIF(A:A,A1)=1)
    as your conditional formatting formula for cell a1 of column A.



    _________________
    Good Luck

    "Give a man a fish, feed him for a meal,
    Teach a man to fish, he will be drunk on a boat every Saturday"

    [ This Message was edited by: IML on 2002-03-06 15:34 ]

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you very much! This works great.
    One other question, I need to add this to some columns with formulas. Will this interfer with those formulas?

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-03-06 19:26, JRolph wrote:
    Thank you very much! This works great.
    One other question, I need to add this to some columns with formulas. Will this interfer with those formulas?
    No, it will not. The conditional formatting formula will calculate based on the results of the formulas in your cells.

    [ This Message was edited by: IML on 2002-03-07 11:24 ]

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