Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have rows of numbers such as:
John Mike Jason Joe Tom 11 12.5 15 17 4 12 14 11 6 5 6 11 9 4 14 ...... For a given row, using conditional formatting, I highlight the lowest number. (min function). From the column perspective, I would like to total the number of times a column (person) had the lowest number. One thing I tried was using a formula such as: =offset(min(A3:E3),-1,0) I was trying to get the name of the person with the lowest number, per row. Then I thought I could do a countif down the columns of names.... Anyway, the offset function I tried has an error in it, and I just can't seem to clear it. Any help would be appreciated. Thanks John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting with COUNTIF | Excel Worksheet Functions | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Countif and conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting And Countif | Excel Discussion (Misc queries) | |||
Countif and Conditional Formatting | Excel Worksheet Functions |