copy selected data only in excel

Toshiba / Tecra m10
June 30, 2010 at 11:12:55
Specs: Microsoft Windows XP Professional, 2.261 GHz / 2011 MB

I was not sure where to ask this question, so that I could properly track the answer.

my query is , I am doing many iterations of 17X17 nuclear fuel, so I have a pin map consisting of 1, 2, 0 . Now pinmap A is made up of 1 and 0 only and PINMAP B is made up of 1 and 2 only , the 0 and 2 dont overlap, how can i merge the two pinmaps.

eg
pinmap A

1 1 1 1 1
1 0 1 0 1
1 0 1 0 1
1 1 1 1 1

pinmap B

1 2 1 2 1
1 1 1 1 1
1 1 1 1 1
1 2 1 2 1

resulting pinmap

1 2 1 2 1
1 0 1 0 1
1 0 1 0 1
1 2 1 2 1

Also is there a automatic way to place a comma "," after the numbers

eg

1, 2, 1, 2, 1/
1, 0, 1, 0, 1/
1, 0, 1, 0, 1/
1, 2, 1, 2, 1/


See More: copy selected data only in excel

Report •

#1
June 30, 2010 at 12:07:41
I was able to duplicate your "resulting pinmap" as follows:

I put pinmap A in A1:E4

I put pinmap B in A6:E9

I put this formula in an empty cell and dragged it across 5 columns and 4 rows.

=IF(AND(A6=A1,A1=1),1,IF(AND(A6=2,A1=1),2,IF(AND(A6=1,A1=0),0)))

It worked for your example...obviously you'll have to test it with other pinmaps.

As far as adding commas:

With a value in A1, use either the Concatenation operator:

=A1 & ","

or the CONCATENATE function:

=CONCATENATE(A1,",")

Let us know if any of that helps.


Report •

#2
June 30, 2010 at 12:19:55
thanks very much , it worked perfect .. thanks so much :) will save me 1 week of manual laboriuous work now

Report •

#3
June 30, 2010 at 12:26:44
Hi,

If pinmap A starts with the first value in Cell A3
and pinmap B start with the first value in Cell A10

Put this formula in an empty cell, e.g., Cell A16
=IF(A3=0,0,IF(A10=2,2,1))

Drag the formula down the 4 rows and then select those 4 cells and drag them accross the 5 columns.
The formula in Cell E19 will be:
=IF(E6=0,0,IF(E13=2,2,1))

To make this appear with commas use this formula:
=IF(A3=0,"0,",IF(A10=2,"2,","1,"))
Drag it to all the cells as before, but in the last column change the , to /


These formulas have only been tested with the sample data you provided - so you need to test them in all possible combinations.
Excel is not certified for safety critical calculations - so no one will be responsible for any resulting nuclear melt-down :)

Regards


Report •

Related Solutions

#4
June 30, 2010 at 12:53:17
thanks for your reply !! my problem has already been fixed :)

Report •

#5
June 30, 2010 at 12:54:43
wow , thats really succinct ,, handled everything in one step

Report •

#6
June 30, 2010 at 15:04:49
Hi,

You're welcome

Regards

Humar


Report •

Ask Question