Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I find the greatest possible sum within 12 months? A newbie... | Excel Worksheet Functions | |||
HOW TO FIND THE GREATEST COMMON FACTOR | Excel Worksheet Functions | |||
Finding the greatest value | Excel Discussion (Misc queries) | |||
Greatest to smallest | Excel Discussion (Misc queries) | |||
in excel conditional formatting find the greatest value in 4rows | Excel Worksheet Functions |