Previous Topic Next Topic

Pickup value in excel cell

Closed
eli88 Posts 2 Registration date Sunday July 26, 2009 Status Member Last seen July 28, 2009 - Jul 27, 2009 at 11:45 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jul 28, 2009 at 09:56 PM
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 response

Answer 1 / 1
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
Jul 27, 2009 at 11:16 PM
Suppose your data started from 2nd Row then write this formula in D2 and drag it down ....
=MAX(A2:C2)
2
eli88 Posts 2 Registration date Sunday July 26, 2009 Status Member Last seen July 28, 2009
Jul 28, 2009 at 08:11 AM
Hi Mubashir,

Great ! Thanks so much...
0
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165 > eli88 Posts 2 Registration date Sunday July 26, 2009 Status Member Last seen July 28, 2009
Jul 28, 2009 at 09:56 PM
Eli you always welcome ....

cheers

0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Excel - IF function with multiple words
Nick -
user -

14 responses