Pickup value in excel cell [Closed]

Report
Posts
2
Registration date
Sunday July 26, 2009
Status
Member
Last seen
July 28, 2009
-
Posts
190
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
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
144
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 2942 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
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
144 >
Posts
2
Registration date
Sunday July 26, 2009
Status
Member
Last seen
July 28, 2009

Eli you always welcome ....

cheers

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!