View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kari Kari is offline
external usenet poster
 
Posts: 16
Default Format cCell to find greatest value

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!!!