[SOLVED] Counting rows, then counting values.

I have a lot of spreadsheets with many rows and columns of numbers. I need
a way to find the highest value in each row, (mark it some how, bold the
number maybe), then count the number of "highest" values are in each
column.

Is there an easy way to do this?

Thank You,
Michael

Hi Michael

You can use this to get the value

=MAX(A1:A20)

and this to count

=COUNTIF(A1:A20,MAX(A1:A20))

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Michael via OfficeKB.com" <[email protected]> wrote in message news:[email protected]...
>I have a lot of spreadsheets with many rows and columns of numbers. I need
> a way to find the highest value in each row, (mark it some how, bold the
> number maybe), then count the number of "highest" values are in each
> column.
>
> Is there an easy way to do this?
>
> Thank You,
> Michael

How can I count how many of the highest values are in each column. Example:
Rows = Hours, Columns = Days. I need to find out which of the hours in each
day is the highests number. Next I need to count how many days have the
same hour as its highest number.

1:00 2:00 3:00 4:00
Monday 12 13 14 15
Tuesday 16 18 25 10
Wednes. 20 14 40 30

Total: 1 1 2 0 <- this is the output im looking for

First part works great, is there a way to do a fill so that I don't have to
do it for every line? How do you I use the countif statement to count the
number of bolded numbers in each column?

Thank you everyone for the help!

Michael

--
Message posted via http://www.officekb.com

See the second formula that I posted
=COUNTIF(A1:A20,MAX(A1:A20))


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Michael via OfficeKB.com" <[email protected]> wrote in message news:[email protected]...
> How can I count how many of the highest values are in each column. Example:
> Rows = Hours, Columns = Days. I need to find out which of the hours in each
> day is the highests number. Next I need to count how many days have the
> same hour as its highest number.
>
> 1:00 2:00 3:00 4:00
> Monday 12 13 14 15
> Tuesday 16 18 25 10
> Wednes. 20 14 40 30
>
> Total: 1 1 2 0 <- this is the output im looking for

Is there a way in which you can make Excel mark the higest number in a row or
column?

Example:

A B C
1 1 3 2

In this example, I would like the cell B3 (or the text in the cell)
automatically highlighted, as it being the higest value of the three cells
A1:C1

Is this possible?

Thank you for any answers!
Thomas Bentsen



"Ron de Bruin" skrev:

> Hi Michael
>
> You can use this to get the value
>
> =MAX(A1:A20)
>
> and this to count
>
> =COUNTIF(A1:A20,MAX(A1:A20))
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Michael via OfficeKB.com" <[email protected]> wrote in message news:[email protected]...
> >I have a lot of spreadsheets with many rows and columns of numbers. I need
> > a way to find the highest value in each row, (mark it some how, bold the
> > number maybe), then count the number of "highest" values are in each
> > column.
> >
> > Is there an easy way to do this?
> >
> > Thank You,
> > Michael
>
>
>

Check out Conditional Formatting in XL Help. One way:


Select A1:C1. Choose Format/Conditional Formatting. Set the dropdowns
and textbox to read

CF1: Formula is =A1=MAX($A$1:$C$1)
Format1: Patterns/<highlight color>



In article <[email protected]>,
"Tbentsen" <[email protected]> wrote:

> Is there a way in which you can make Excel mark the higest number in a row or
> column?
>
> Example:
>
> A B C
> 1 1 3 2
>
> In this example, I would like the cell B3 (or the text in the cell)
> automatically highlighted, as it being the higest value of the three cells
> A1:C1
>
> Is this possible?