Search : in
By :

Pickup value in excel cell

Last answer on Jul 29, 2009 2:56:14 am BST eli88, on Jul 27, 2009 4:45:10 pm BST 
 Report this message to moderators

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

Configuration: Windows Internet Explorer 8.0

Best answers for « pickup value in excel cell » in :
Excel tips : How to insert date In an Excel cell ShowExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current...
VB6 Finding the RGB values of a color ShowVB6 Finding the RGB values of a color Dim R as integer Dim G as integer Dim B as integer Sub FindRGB(Col As Long) R = &HFF& And Col G = (&HFF00& And Col ) \ 256 B = (&HFF0000 And Col ) \ 65536 End Sub Note: Here...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
CSS - Style sheets ShowFont properties Property Value Description font-family Specific font (Arial, Times, Verdana) Familly (serif, sans-serif, fantasy, monospace, cursive) Defines one or more font names or font families. If multiple fonts are defined,...

1

mubashir aziz, on Jul 28, 2009 4:16:51 am BST
  • +1

Suppose your data started from 2nd Row then write this formula in D2 and drag it down ....
=MAX(A2:C2)
Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan

Reply to mubashir aziz

2

eli88, on Jul 28, 2009 1:11:06 pm BST

Hi Mubashir,

Great ! Thanks so much...

Reply to eli88

3

 mubashir aziz, on Jul 29, 2009 2:56:14 am BST

Eli you always welcome ....

cheers

NeverashamedtogetorgiveAdvise.
MuhammadMubashirAziz,Lodhran,Pakistan

Reply to mubashir aziz