Excel Golf Skins Sheet [Solved/Closed]

Posts
2
Registration date
Sunday August 17, 2014
Last seen
August 18, 2014
- - Latest reply: agw2010
Posts
2
Registration date
Sunday August 17, 2014
Last seen
August 18, 2014
- Aug 18, 2014 at 10:20 PM
I need a micro that will highlight the cell with the lowest unique value in each individual column.

It would not highlight anything if there were multiple occurrences of the same lowest number.

I know how to do it in old basic, but not in excel visual basic.

Example: 2 3 4 4 4 3 5 - it would highlight the 2

Example: 3 5 7 4 3 4 4 5 5 - no highlight due to multiple 3s

Thanks in advance.
See more 

2 replies

Best answer
Posts
2441
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 18, 2018
400
2
Thank you
Hi Agw,

You could use a spare cell for this formula:
=IF(COUNTIF(A1:A9,MIN(A1:A9))=1,MIN(A1:A9))

and then use this in Conditional formatting:
=$A1:$A9=$C$22 (Where C22 is the cell with the above formula.)

Best regards,
Trowa

Say "Thank you" 2

A few words of thanks would be greatly appreciated. Add comment

CCM 4406 users have said thank you to us this month

Posts
2
Registration date
Sunday August 17, 2014
Last seen
August 18, 2014
0
Thank you
Wonderful!!

Works Great!!

Thanks!!