| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto add data based on value in another column
Hi, I want to automatically add data in a column depending on the value of
data in another column. For example, if column one has a value of 1,3,9 or 12 then a value of 1 is automatically entered in column 2; if column one has a value of 2,4,7,8 or 11 then a value of 2 is automatically entered in column 2.... and so on. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to auto add data based on value in another column
One way
Assuming data is in A1 down in B1: =IF(ISNUMBER(MATCH(A1,{1;3;9;12},0)),1,IF(ISNUMBER (MATCH(A1,{2;4;7;8;11},0)),2,"")) Copy down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "AlanMB" wrote: Hi, I want to automatically add data in a column depending on the value of data in another column. For example, if column one has a value of 1,3,9 or 12 then a value of 1 is automatically entered in column 2; if column one has a value of 2,4,7,8 or 11 then a value of 2 is automatically entered in column 2.... and so on. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to auto add data based on value in another column
Max
What about the "and so on"<g Gord On Tue, 20 May 2008 06:24:01 -0700, Max wrote: One way Assuming data is in A1 down in B1: =IF(ISNUMBER(MATCH(A1,{1;3;9;12},0)),1,IF(ISNUMBE R(MATCH(A1,{2;4;7;8;11},0)),2,"")) Copy down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "AlanMB" wrote: Hi, I want to automatically add data in a column depending on the value of data in another column. For example, if column one has a value of 1,3,9 or 12 then a value of 1 is automatically entered in column 2; if column one has a value of 2,4,7,8 or 11 then a value of 2 is automatically entered in column 2.... and so on. Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to auto add data based on value in another column
.. What about the "and so on"<g
Aha, I missed that, Gord. Guess I should have said: "Try something like .. " -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to auto add data based on value in another column
I always have a problem with the "and so on" and "etc."
How many is "and so on"? Gord On Wed, 21 May 2008 02:19:30 +0800, "Max" wrote: .. What about the "and so on"<g Aha, I missed that, Gord. Guess I should have said: "Try something like .. " |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to auto add data based on value in another column
Agreed, subjective. And that could well form the subject of a new post by
the OP. But as-is, think the OP is quite happy with the response. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I always have a problem with the "and so on" and "etc." How many is "and so on"? Gord |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
| Auto column insertion based on a number | Excel Worksheet Functions | |||
| y-axis auto range based on data limits | Charts and Charting in Excel | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| Auto fill Column based on data in other columns | New Users to Excel | |||
Hybrid Mode
