Previous Topic Next Topic

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

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

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

CCM 2942 users have said thank you to us this month

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

Great ! Thanks so much...
Report
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
 155 >
Posts
2
Registration date
Sunday July 26, 2009
Status
Member
Last seen
July 28, 2009
Eli you always welcome ....

cheers

Ask a question