Copying values

Mar 7th, 2002, 12:56 PM

Hello People
I am just wondering if I have a spreadsheet with the following format
Test1 11
Test2 22
Test3 33
Test4 33
Test1 33
Test2 33
Test3 11
Test4 22
...
...
Is there a way to create another column and copy the value from Test1 directly to that new column?
eg.
11 Test1 11
Test2 22
Test3 33
Test4 33
33 Test1 33
Test2 33
Test3 11
Test4 22
Please Help me
Thank you

Barrie Davidson · Mar 7th, 2002, 05:09 PM

Quote:

On 2002-03-07 11:56, Anonymous wrote:
Hello People
I am just wondering if I have a spreadsheet with the following format
Test1 11
Test2 22
Test3 33
Test4 33
Test1 33
Test2 33
Test3 11
Test4 22
...
...
Is there a way to create another column and copy the value from Test1 directly to that new column?
eg.
11 Test1 11
Test2 22
Test3 33
Test4 33
33 Test1 33
Test2 33
Test3 11
Test4 22
Please Help me
Thank you

How about inserting a column and using an IF statement to populate that column? So your IF formula would be:

=IF(B1="Test1",C1,"")

Would that work for you?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 12:56 PM	#1
Guest Posts: n/a	Hello People I am just wondering if I have a spreadsheet with the following format Test1 11 Test2 22 Test3 33 Test4 33 Test1 33 Test2 33 Test3 11 Test4 22 ... ... Is there a way to create another column and copy the value from Test1 directly to that new column? eg. 11 Test1 11 Test2 22 Test3 33 Test4 33 33 Test1 33 Test2 33 Test3 11 Test4 22 Please Help me Thank you