LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Countif with conditional formatting

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting with COUNTIF Rovermog Excel Worksheet Functions 2 September 23rd 09 12:16 PM
Protect Cell Formatting including Conditional Formatting Mick Jennings Excel Discussion (Misc queries) 5 November 13th 07 05:32 PM
Countif and conditional formatting SLKPM Excel Discussion (Misc queries) 0 September 30th 05 10:35 AM
Conditional Formatting And Countif cafe Excel Discussion (Misc queries) 6 August 10th 05 08:40 PM
Countif and Conditional Formatting Ramiro Espinoza Excel Worksheet Functions 1 February 2nd 05 05:21 PM


All times are GMT +1. The time now is 08:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"