Previous Topic Next Topic

Pickup value in excel cell

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

1 response

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

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

cheers

Similar discussions

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

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

6 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Convert number to spelling
Sukumar -
mrwagh85 -

28 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses