[SOLVED] Counting rows, then counting values.

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" <forum@nospam.OfficeKB.com> wrote in message news:152907df2ac24b6ab6ee8d51d46958d9@OfficeKB.com...
> >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 <D7959FED-DE63-4CFA-9649-07AB6AC0B481@microsoft.com>,
"Tbentsen" <Tbentsen@discussions.microsoft.com> 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?