Pickup value in excel cell [Closed]

Report
Posts
2
Registration date
Sunday July 26, 2009
Status
Member
Last seen
July 28, 2009
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,

someone advise me the excel questions :-
would like to pickup highest value from column A to C and and put result in column D
e.g.

A, B, C, D (Expected Result)
100, 200, 150, 200
110, 198, 370, 370
333, 110, 270, 333


Thanks

1 reply

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
212
Suppose your data started from 2nd Row then write this formula in D2 and drag it down ....
=MAX(A2:C2)
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3377 users have said thank you to us this month

Posts
2
Registration date
Sunday July 26, 2009
Status
Member
Last seen
July 28, 2009

Hi Mubashir,

Great ! Thanks so much...
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
212 >
Posts
2
Registration date
Sunday July 26, 2009
Status
Member
Last seen
July 28, 2009

Eli you always welcome ....

cheers