Count IF Array of sorts... What am I missing?

[svelte]

What I have is a spreadsheet of four columns of numbers (B11:E999).

These numbers are conditionally formatted to appear in .RED if it's th
highest number in the row and BLUE if it's the second highest in th
row. This bit of information may be irrelevant.

What I'm trying to do is add a count (ROWs above 11) of the number o
times a column contains the highest or second highest number. I'
thinking this is not that hard, but it's not clicking for me today.

Example:

Code
-------------------
___________A_______B_____C_____D_____E___
7|Count of High | 2 | 0 | 1 | 4
8|Count of 2nd's | 3 | 3 | 1 | 0
| | | | |
| | | | |
11|Day 1 | 4 | 3 | 1 | 2
12|Day 2 | 1 | 3 | 4 | 2
13|Day 3 | 3 | 2 | 1 | 4
14|Day 4 | 4 | 1 | 3 | 2
15|Day 5 | 3 | 2 | 1 | 4
16|Day 6 | 3 | 1 | 2 | 4
17|Day 7 | 2 | 3 | 1 |

 

[Ken Wright]

=COUNTIF(Range,LARGE(Range,1)) or
=COUNTIF(Range,MAX(Range))

for count of largest, and

=COUNTIF(Range,LARGE(Range,2))

for count of 2nd largest

 

[svelte]

So.... maybe this one is harder than I thought...

No ideas out there, eh

 

[Harlan Grove]

So.... maybe this one is harder than I thought...

No ideas out there, eh?

Apparently you missed Ken Wright's response because ExcelForum didn't catch
it. That's one of the dangers in using a browser-based newsgroup interface -
too damn much artwork requiring too damn much of the server's processing
time, causing missed posts.

Grow up - use a real newsreader and a real news server. Or learn how to
search Google Groups.

http://groups.google.com/[email protected]