| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Choosing a cell with the greater number
Column A has a list of numbers and Column B has a list of numbers. In column
C, I would like it to select the greater number from cell A or B. Can somebody tell me how to formulate that? Thank you. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Choosing a cell with the greater number
=MAX(A1,B1)
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Maddie" wrote: Column A has a list of numbers and Column B has a list of numbers. In column C, I would like it to select the greater number from cell A or B. Can somebody tell me how to formulate that? Thank you. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Choosing a cell with the greater number
Thank you, I've been racking my brains on this and it was so simple. You're
a lifesaver! -Maddie "Luke M" wrote: =MAX(A1,B1) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Maddie" wrote: Column A has a list of numbers and Column B has a list of numbers. In column C, I would like it to select the greater number from cell A or B. Can somebody tell me how to formulate that? Thank you. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Choosing a cell with the greater number
If I understand correctly, try this and pull down in column C.
=LARGE(A1:B1,1) If you want the largest number from either column A or B then try this in C1. =LARGE(A1:B50,1) HTH Regards, Howard "Maddie" wrote in message ... Column A has a list of numbers and Column B has a list of numbers. In column C, I would like it to select the greater number from cell A or B. Can somebody tell me how to formulate that? Thank you. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Choosing a cell with the greater number
In column c -
=IF(A1B1,A1,B1) |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Choosing a cell with the greater number
Maddie
Try, in column C (c1) =max(a1:b1) Copy down column c for a row by row determination of the greater of column A or B. Ken On Dec 15, 3:21*pm, Maddie wrote: Column A has a list of numbers and Column B has a list of numbers. *In column C, *I would like it to select the greater number from cell A or B. *Can somebody tell me how to formulate that? *Thank you. * |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Choosing a cell with the greater number
In cell C1, enter: =Max(A1,B1). Then, copy this formula down column C
as needed. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Choosing a cell with the greater number
On Dec 15, 3:21 pm, Maddie wrote:
Column A has a list of numbers and Column B has a list of numbers. In column C, I would like it to select the greater number from cell A or B. Can somebody tell me how to formulate that? Thank you. Try using the MAX function. For example, if you have a number in cell A1 and another number in cell B1, place the following formula in cell C1: =MAX(A1,B1). I think that this is what you are asking. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a cell red if number is not greater than needed? | Excel Worksheet Functions | |||
| Make a cell font red if number is greater than 200 | Excel Discussion (Misc queries) | |||
| putting a number that is greater or lesser into different cell . | Excel Worksheet Functions | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| find cell with value greater than my number | Excel Programming | |||
Linear Mode
