Re: Max(s5:s69)...help

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Aladin Akyurek (akyurek_at_xs4all.nl)
Date: 08/25/04 

Date: Thu, 26 Aug 2004 01:20:54 +0200

Yes, you are on the right track with CoutIf per name. You need to apply a
Rank formula to the counts so obtained. See

http://tinyurl.com/34w7d

for the formula system you need.

"ForSale >" <<ForSale.1bkh6r@excelforum-nospam.com> wrote in message
news:ForSale.1bkh6r@excelforum-nospam.com...
> i have a list of names in column A and numbers corresponding to these
> names in columns C:N. now, i need to have one cell that will display
> the name of the person with the most 100's. let me know if i am on the
> right track with making a column of =countif(c5:n5,100) and then at the
> bottom of that column a =max(s5:s69). this is displaying the row with
> the most 100's, but how do i display the name of that person?
> thanks
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Quantcast