First days newbie

  • Thread starter Thread starter Treeskier
  • Start date Start date
T

Treeskier

Just learning on my own here!
This is about as simple as I can explain this and it probably is.

I have three columns of triple digit numbers "bids" in a row each day.
At a bottom row "Total" I would like the column with the highest number each
day
to be adding/reflect 1 "Win"
 
With your data in A1:C200, in cell A201 put the following formula and copy
across to B201:C201

=IF(MAX(A$1:A$200)=MAX($A$1:$C$200),"Win","")

Can two columns contain the same winning number?
 
You can also identify the maximum using formatting:

1. Highlight your list (assume A5:C200) starting with A5

2. Click Format-->Conditional Formatting

3. Change the first dropdown to "Formula is"

4. Place the following formula in the box to the right of the dropdown:

=AND(LEN(A5)>0,A5=MAX(A$5:A$200))

This formula checks the cell (A5) to make sure there's something in it
(using the LEN function) AND checks A5 to see if it's the largest (MAX)
value in the range A5:A200.

5. Click the Format button and change the look as desired (Font
color/bolding/background color/borders)

6. Click OK twice.



--
_________________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com
 
Thank You very much!

Robert Rosenberg said:
You can also identify the maximum using formatting:

1. Highlight your list (assume A5:C200) starting with A5

2. Click Format-->Conditional Formatting

3. Change the first dropdown to "Formula is"

4. Place the following formula in the box to the right of the dropdown:

=AND(LEN(A5)>0,A5=MAX(A$5:A$200))

This formula checks the cell (A5) to make sure there's something in it
(using the LEN function) AND checks A5 to see if it's the largest (MAX)
value in the range A5:A200.

5. Click the Format button and change the look as desired (Font
color/bolding/background color/borders)

6. Click OK twice.



--
_________________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com
Click to expand...
 
Back
Top