| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picking numbers from 2 columns - need help
I've hacked at this for a while and can't figure it out. I really need
it for an office project. What formula do I use for Column C, when: There are numbers in Column A, but not in all of the cells in that column. There are numbers in Column B, but not in all of the cells in that column. Every row has a number in either Column A, Column B, or both. In every row, in Column C: If there is a number in Column B, show that number in Column C, otherwise show the number in Column A. Please help me out, thanks. Reply to the group. Ron M. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Picking numbers from 2 columns - need help
=IF(ISNUMBER(B1),B1,A1)
HTH Otto wrote in message ups.com... I've hacked at this for a while and can't figure it out. I really need it for an office project. What formula do I use for Column C, when: There are numbers in Column A, but not in all of the cells in that column. There are numbers in Column B, but not in all of the cells in that column. Every row has a number in either Column A, Column B, or both. In every row, in Column C: If there is a number in Column B, show that number in Column C, otherwise show the number in Column A. Please help me out, thanks. Reply to the group. Ron M. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Picking numbers from 2 columns - need help
In C1:
=if(B1<"",B1,A1) then drag fill down the column -- Regards, Tom Ogilvy " wrote: I've hacked at this for a while and can't figure it out. I really need it for an office project. What formula do I use for Column C, when: There are numbers in Column A, but not in all of the cells in that column. There are numbers in Column B, but not in all of the cells in that column. Every row has a number in either Column A, Column B, or both. In every row, in Column C: If there is a number in Column B, show that number in Column C, otherwise show the number in Column A. Please help me out, thanks. Reply to the group. Ron M. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Picking numbers from 2 columns - need help
Reading some of the other responses, mine would only work if the non numeric
cells were blank (which was what I envisioned). -- Regards, Tom Ogilvy "Tom Ogilvy" wrote: In C1: =if(B1<"",B1,A1) then drag fill down the column -- Regards, Tom Ogilvy " wrote: I've hacked at this for a while and can't figure it out. I really need it for an office project. What formula do I use for Column C, when: There are numbers in Column A, but not in all of the cells in that column. There are numbers in Column B, but not in all of the cells in that column. Every row has a number in either Column A, Column B, or both. In every row, in Column C: If there is a number in Column B, show that number in Column C, otherwise show the number in Column A. Please help me out, thanks. Reply to the group. Ron M. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Picking numbers from 2 columns - need help
=IF(ISNUMBER(B1),B1,IF(ISNUMBER(A1),A1,""))
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message ups.com... I've hacked at this for a while and can't figure it out. I really need it for an office project. What formula do I use for Column C, when: There are numbers in Column A, but not in all of the cells in that column. There are numbers in Column B, but not in all of the cells in that column. Every row has a number in either Column A, Column B, or both. In every row, in Column C: If there is a number in Column B, show that number in Column C, otherwise show the number in Column A. Please help me out, thanks. Reply to the group. Ron M. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Picking numbers from 2 columns - need help
Thanks, guys. You'll never pay for a drink when I'm around. Ron M. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XY Scatter graph: x-axis picking up row numbers instead of values | Charts and Charting in Excel | |||
| compare 2 columns of numbers and place the matched numbers in a 3r | Excel Discussion (Misc queries) | |||
| split range of numbers in two columns to as many as numbers in ran | Excel Discussion (Misc queries) | |||
| Find similar numbers from two columns of numbers | Excel Discussion (Misc queries) | |||
| Picking data | Excel Worksheet Functions | |||
Hybrid Mode
