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 Jony Ive could make a big impact on Airbnb?

Discuss in The Lounge

Poll History