| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula question
Hi there, im tring to write a formula to look at data from another worksheet
at every 3rd column so that I would have the following; Sheet 1 A1 = Sheet 2 D14 A2 = G14 A3 = J14 A4 = M14 ETC... Any help would be great :) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula question
"Scott R" wrote...
Hi there, im tring to write a formula to look at data from another worksheet at every 3rd column so that I would have the following; Sheet 1 A1 = Sheet 2 D14 A2 = G14 A3 = J14 A4 = M14 ETC... Sheet1!A1: =INDEX(Sheet2!$14:$14,1+3*ROWS(A$1:A1)) Fill Sheet1!A1 down as far as needed. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula question
I put that formula in and it said there was an error, when i click ok it
refers back to the 1st of the 14's in the formula? Am i doing something wrong? "Harlan Grove" wrote: "Scott R" wrote... Hi there, im tring to write a formula to look at data from another worksheet at every 3rd column so that I would have the following; Sheet 1 A1 = Sheet 2 D14 A2 = G14 A3 = J14 A4 = M14 ETC... Sheet1!A1: =INDEX(Sheet2!$14:$14,1+3*ROWS(A$1:A1)) Fill Sheet1!A1 down as far as needed. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula question
i might not have wrote it right in the beginning, what i have are rows in
sheet 1 that need to copy data from every 3rd Column in sheet 2 "Scott R" wrote: I put that formula in and it said there was an error, when i click ok it refers back to the 1st of the 14's in the formula? Am i doing something wrong? "Harlan Grove" wrote: "Scott R" wrote... Hi there, im tring to write a formula to look at data from another worksheet at every 3rd column so that I would have the following; Sheet 1 A1 = Sheet 2 D14 A2 = G14 A3 = J14 A4 = M14 ETC... Sheet1!A1: =INDEX(Sheet2!$14:$14,1+3*ROWS(A$1:A1)) Fill Sheet1!A1 down as far as needed. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula question
Did you cut and paste the formula directly from Harlan's message, or did you
try to retype it? Do you want to copy and paste the formula back from your formula bar to here? Is your Sheet2 actually named Sheet2? If it is Sheet 2 with a space, try =INDEX('Sheet 2'!$14:$14,1+3*ROWS(A$1:A1)) -- David Biddulph "Scott R" wrote in message ... I put that formula in and it said there was an error, when i click ok it refers back to the 1st of the 14's in the formula? Am i doing something wrong? "Harlan Grove" wrote: "Scott R" wrote... Hi there, im tring to write a formula to look at data from another worksheet at every 3rd column so that I would have the following; Sheet 1 A1 = Sheet 2 D14 A2 = G14 A3 = J14 A4 = M14 ETC... Sheet1!A1: =INDEX(Sheet2!$14:$14,1+3*ROWS(A$1:A1)) Fill Sheet1!A1 down as far as needed. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula question
David ive completely stuffed this up. this is what I need.
D5 (sheet 1) = D14 (sheet 2) F5 = G14 H5 = J14 etc.. I pasted the formula in but it gives me the value from D14 for all cells that i copy the formula into?? "David Biddulph" wrote: Did you cut and paste the formula directly from Harlan's message, or did you try to retype it? Do you want to copy and paste the formula back from your formula bar to here? Is your Sheet2 actually named Sheet2? If it is Sheet 2 with a space, try =INDEX('Sheet 2'!$14:$14,1+3*ROWS(A$1:A1)) -- David Biddulph "Scott R" wrote in message ... I put that formula in and it said there was an error, when i click ok it refers back to the 1st of the 14's in the formula? Am i doing something wrong? "Harlan Grove" wrote: "Scott R" wrote... Hi there, im tring to write a formula to look at data from another worksheet at every 3rd column so that I would have the following; Sheet 1 A1 = Sheet 2 D14 A2 = G14 A3 = J14 A4 = M14 ETC... Sheet1!A1: =INDEX(Sheet2!$14:$14,1+3*ROWS(A$1:A1)) Fill Sheet1!A1 down as far as needed. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula question
Thanks guys, the formula worked, (i was doing it wrong).
Cheers Scott "Scott R" wrote: David ive completely stuffed this up. this is what I need. D5 (sheet 1) = D14 (sheet 2) F5 = G14 H5 = J14 etc.. I pasted the formula in but it gives me the value from D14 for all cells that i copy the formula into?? "David Biddulph" wrote: Did you cut and paste the formula directly from Harlan's message, or did you try to retype it? Do you want to copy and paste the formula back from your formula bar to here? Is your Sheet2 actually named Sheet2? If it is Sheet 2 with a space, try =INDEX('Sheet 2'!$14:$14,1+3*ROWS(A$1:A1)) -- David Biddulph "Scott R" wrote in message ... I put that formula in and it said there was an error, when i click ok it refers back to the 1st of the 14's in the formula? Am i doing something wrong? "Harlan Grove" wrote: "Scott R" wrote... Hi there, im tring to write a formula to look at data from another worksheet at every 3rd column so that I would have the following; Sheet 1 A1 = Sheet 2 D14 A2 = G14 A3 = J14 A4 = M14 ETC... Sheet1!A1: =INDEX(Sheet2!$14:$14,1+3*ROWS(A$1:A1)) Fill Sheet1!A1 down as far as needed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| formula question | Excel Discussion (Misc queries) | |||
| Formula Question | Excel Discussion (Misc queries) | |||
| Formula Question | Excel Discussion (Misc queries) | |||
| Formula Question | Excel Worksheet Functions | |||
Linear Mode
