View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 698
Default 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!!!