|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 13th, 2009, 08:07 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
Hi
I wonder if it can be done by formula. I have the following: Col1 col2 col3 col4 data1 data1 number1 number2 data2 data2 number3 number4 I would like to create new sheet with Col1 col2 col3 col4 data1 data1 number1 (first row) data1 data1 number2 (First row) data2 data2 number3 (second row) data2 data2 number4 (second row) It will be great if I can have only data from col 3&4 that are more than 0, but it is not a big deal if it can't be done. Any ideas? -- Greatly appreciated Eva 
|
|
#2
November 13th, 2009, 09:01 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
Not sure if a formula is needed.. Can just copy columns A through C and pate,
then append columns A, B and D, then sort by A and B... "Eva" wrote: Hi I wonder if it can be done by formula. I have the following: Col1 col2 col3 col4 data1 data1 number1 number2 data2 data2 number3 number4 I would like to create new sheet with Col1 col2 col3 col4 data1 data1 number1 (first row) data1 data1 number2 (First row) data2 data2 number3 (second row) data2 data2 number4 (second row) It will be great if I can have only data from col 3&4 that are more than 0, but it is not a big deal if it can't be done. Any ideas? -- Greatly appreciated Eva
|
|
#3
November 13th, 2009, 11:18 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
Hi
No, there are many rows and they want to have this automated. they don't want to copy and paste each time they need to create new sheet with data. -- Greatly appreciated Eva "Sean Timmons" wrote: Not sure if a formula is needed.. Can just copy columns A through C and pate, then append columns A, B and D, then sort by A and B... "Eva" wrote: Hi I wonder if it can be done by formula. I have the following: Col1 col2 col3 col4 data1 data1 number1 number2 data2 data2 number3 number4 I would like to create new sheet with Col1 col2 col3 col4 data1 data1 number1 (first row) data1 data1 number2 (First row) data2 data2 number3 (second row) data2 data2 number4 (second row) It will be great if I can have only data from col 3&4 that are more than 0, but it is not a big deal if it can't be done. Any ideas? -- Greatly appreciated Eva
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
