Format cCell to find greatest value
Try something like this:
D1: =MAX(A1:C1)
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Kari" wrote:
I have a spreadsheet that I am working with and I am stumped on a formula
that I wish to create.
I have three columns (A, B & C) that have multiple rows of data that vary
based on what is entered for that day. I wish to have column D automatically
fill with the data that is the greatest value out of the three previous cells.
See below - I want cell D to automatically "grab" the 98, 105, and so on;
A B C D
51 45 98 *
38 105 73 *
...
...
Thanks for your help!!!
|