Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

3 views
Skip to first unread message

svelte

unread,
Nov 19, 2003, 3:00:25 PM11/19/03
to

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 the
highest number in the row and BLUE if it's the second highest in the
row. This bit of information may be irrelevant.

What I'm trying to do is add a count (ROWs above 11) of the number of
times a column contains the highest or second highest number. I'm
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 | 4
--------------------


Clear as mud? Thanks for any suggestions.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Ken Wright

unread,
Nov 19, 2003, 4:38:25 PM11/19/03
to
=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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Newsgroups - Where you really can get a free lunch!!
----------------------------------------------------------------------------

"svelte" <svelte...@excelforum-nospam.com> wrote in message
news:svelte...@excelforum-nospam.com...


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.541 / Virus Database: 335 - Release Date: 14/11/2003


svelte

unread,
Nov 26, 2003, 3:57:14 PM11/26/03
to

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

No ideas out there, eh?

Harlan Grove

unread,
Nov 26, 2003, 4:09:57 PM11/26/03
to
"svelte" <svelte...@excelforum-nospam.com> wrote...

>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/groups?selm=uJOR5VurDHA.556%40TK2MSFTNGP11.phx.gbl


0 new messages