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

  • Thread starter Thread starter svelte
  • Start date Start date
S

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 |
 
=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 said:
So.... maybe this one is harder than I thought...

No ideas out there, eh?
Click to expand...

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]
 
Back
Top