# 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 A1 1 1 1 11 0 1 0 11 0 1 0 11 1 1 1 1pinmap B1 2 1 2 11 1 1 1 11 1 1 1 11 2 1 2 1resulting pinmap1 2 1 2 11 0 1 0 11 0 1 0 11 2 1 2 1Also is there a automatic way to place a comma "," after the numberseg1, 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

#1
June 30, 2010 at 12:07:41
 I was able to duplicate your "resulting pinmap" as follows:I put pinmap A in A1:E4I put pinmap B in A6:E9I 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 A3and 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

Report •

Related Solutions

#4
June 30, 2010 at 12:53:17

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 welcomeRegardsHumar

Report •