Previous Topic Next Topic

Excel Golf Skins Sheet

Solved/Closed
agw2010 Posts 2 Registration date Sunday August 17, 2014 Status Member Last seen August 18, 2014 - Aug 17, 2014 at 11:32 PM
agw2010 Posts 2 Registration date Sunday August 17, 2014 Status Member 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.
Related:

2 responses

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Aug 18, 2014 at 12:06 PM
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
3

Similar discussions

Automatically update master worksheet from other worksheets
Saktivel -
vcoolio -

18 responses
need to find formula to say happy birthday
whitedevil65 -
rizvisa1 -

4 responses
Linking Excel Data to Excel-Based Calendar
mcamp63 -
rizvisa1 -

1 response
Auto notify or mail when Excel sheet updated.
Satya -
cdb2013 -

20 responses
macro to compare two excel sheets
annajins -
Aks -

6 responses
Excel if range of cell contain a text put a cell value in
diegomagum -
TrowaD -

11 responses