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.

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.

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.

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
---

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 .. "

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