Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
which function to use
Hi, I have 2 sheets in a workbook -Sheet 1 and sheet 2. I have data in sheet 2 as follows: Row ColumnA 1 data1 2 data2 3 data3 Now I want to put a formula in Sheet 1 to get the data from Sheet 2 as follows: Row ColumnA 1 =Sheet2!A1 2 ----- 3 =Sheet2!A2 (when I copy, the formula is =Sheet2!A3) 4 ----- 5 =Sheet2!A3 On sheet 1 , I am skipping a row when copying the formula and because of this I am getting the formula all messed up. Please help. Thanks -- jijy ------------------------------------------------------------------------ jijy's Profile: http://www.excelforum.com/member.php...o&userid=15042 View this thread: http://www.excelforum.com/showthread...hreadid=547968 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
which function to use
Jijy for how many rows you talking about?
regards from Brazil Marcelo "jijy" escreveu: Hi, I have 2 sheets in a workbook -Sheet 1 and sheet 2. I have data in sheet 2 as follows: Row ColumnA 1 data1 2 data2 3 data3 Now I want to put a formula in Sheet 1 to get the data from Sheet 2 as follows: Row ColumnA 1 =Sheet2!A1 2 ----- 3 =Sheet2!A2 (when I copy, the formula is =Sheet2!A3) 4 ----- 5 =Sheet2!A3 On sheet 1 , I am skipping a row when copying the formula and because of this I am getting the formula all messed up. Please help. Thanks -- jijy ------------------------------------------------------------------------ jijy's Profile: http://www.excelforum.com/member.php...o&userid=15042 View this thread: http://www.excelforum.com/showthread...hreadid=547968 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
which function to use
You could use a helper column in Sheet2. In an empty column next to your
data, enter 1 in the first row, then 3 in the second row. Select these two cells and drag down as far as your data. Then, below your data enter a 2 in the first empty row, then 4, select and drag down as far as you need. Then sort your data on this helper column and the empty rows will be inserted between your data. A B 1 1 =Sheet2!A1 2 3 =Sheet2!A2 3 5 =Sheet2!A3 4 2 5 4 6 6 "jijy" wrote: Hi, I have 2 sheets in a workbook -Sheet 1 and sheet 2. I have data in sheet 2 as follows: Row ColumnA 1 data1 2 data2 3 data3 Now I want to put a formula in Sheet 1 to get the data from Sheet 2 as follows: Row ColumnA On sheet 1 , I am skipping a row when copying the formula and because of this I am getting the formula all messed up. Please help. Thanks -- jijy ------------------------------------------------------------------------ jijy's Profile: http://www.excelforum.com/member.php...o&userid=15042 View this thread: http://www.excelforum.com/showthread...hreadid=547968 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |