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

1 0 1 0 1

1 0 1 0 1

1 1 1 1 1pinmap B

1 2 1 2 1

1 1 1 1 1

1 1 1 1 1

1 2 1 2 1resulting pinmap

1 2 1 2 1

1 0 1 0 1

1 0 1 0 1

1 2 1 2 1Also 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/

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.

thanks very much , it worked perfect .. thanks so much :) will save me 1 week of manual laboriuous work now

Hi, If pinmap A starts with the first value in Cell A3

and pinmap B start with the first value in Cell A10Put 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

thanks for your reply !! my problem has already been fixed :)

wow , thats really succinct ,, handled everything in one step

Hi, You're welcome

Regards

Humar

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History