Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel question? Regarding cell formula
If cell A12 pulls information from Cell A129, i.e. (=A129) how do I create a
formula that will pull A172 to cell A13? |
#2
|
|||
|
|||
Just like your current formula in cell ...
A12: =A129 you create a formula for cell ... A13: =A172 "Kristin" wrote in message ... If cell A12 pulls information from Cell A129, i.e. (=A129) how do I create a formula that will pull A172 to cell A13? |
#3
|
|||
|
|||
"=A172" in A13 without the quotes.
Is this what you want? HTH Otto "Kristin" wrote in message ... If cell A12 pulls information from Cell A129, i.e. (=A129) how do I create a formula that will pull A172 to cell A13? |
#4
|
|||
|
|||
"David McRitchie" wrote: Just like your current formula in cell ... A12: =A129 you create a formula for cell ... A13: =A172 "Kristin" wrote in message ... If cell A12 pulls information from Cell A129, i.e. (=A129) how do I create a formula that will pull A172 to cell A13? Thanks, but how do I create a formula that will continue to pull information from a cell 43 rows down and continue......................to do the same....is that possible so that I don't have to type the infomation into each cell? |
#5
|
|||
|
|||
Thanks............................and to continue this pattern without typing
it each cell?????? "Otto Moehrbach" wrote: "=A172" in A13 without the quotes. Is this what you want? HTH Otto "Kristin" wrote in message ... If cell A12 pulls information from Cell A129, i.e. (=A129) how do I create a formula that will pull A172 to cell A13? |
#6
|
|||
|
|||
Hi Kristin,
Please put your response BEFORE the quoted previous responses, your newsreader is not distinguishing your replies from the previous response, It all looks like quoted material. Best to describe what you want the first time. You might get a better idea from these two pages http://www.mvps.org/dmcritchie/excel/fillhand.htm Fill Handle http://www.mvps.org/dmcritchie/excel/snakecols.htm Snake columns http://www.mvps.org/dmcritchie/excel/offset.htm use of OFFSET A13 A1: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A26 A2: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A39 A3: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A52 A4: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A65 A5: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A78 A6: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A91 A7: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A104 A8: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A117 A9: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A130 A10: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A143 A11: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A156 A12: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A169 A13: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A182 A14: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kristin" wrote in message ... "David McRitchie" wrote: Just like your current formula in cell ... A12: =A129 you create a formula for cell ... A13: =A172 "Kristin" wrote in message ... If cell A12 pulls information from Cell A129, i.e. (=A129) how do I create a formula that will pull A172 to cell A13? Thanks, but how do I create a formula that will continue to pull information from a cell 43 rows down and continue......................to do the same....is that possible so that I don't have to type the infomation into each cell? |
#7
|
|||
|
|||
Thanks not sure what I'm doing here so all info is appreciated!
"David McRitchie" wrote: Hi Kristin, Please put your response BEFORE the quoted previous responses, your newsreader is not distinguishing your replies from the previous response, It all looks like quoted material. Best to describe what you want the first time. You might get a better idea from these two pages http://www.mvps.org/dmcritchie/excel/fillhand.htm Fill Handle http://www.mvps.org/dmcritchie/excel/snakecols.htm Snake columns http://www.mvps.org/dmcritchie/excel/offset.htm use of OFFSET A13 A1: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A26 A2: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A39 A3: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A52 A4: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A65 A5: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A78 A6: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A91 A7: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A104 A8: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A117 A9: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A130 A10: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A143 A11: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A156 A12: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A169 A13: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A182 A14: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kristin" wrote in message ... "David McRitchie" wrote: Just like your current formula in cell ... A12: =A129 you create a formula for cell ... A13: =A172 "Kristin" wrote in message ... If cell A12 pulls information from Cell A129, i.e. (=A129) how do I create a formula that will pull A172 to cell A13? Thanks, but how do I create a formula that will continue to pull information from a cell 43 rows down and continue......................to do the same....is that possible so that I don't have to type the infomation into each cell? |
#8
|
|||
|
|||
Hi Kristin,
Not sure whether that means what I wrote is not understood. I could create a workbook with what was tested. My example shows the results in column A, and column B shows the address in column A with it's formula. The use of the fill handle is what makes it simple (see links previously supplied) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Kristin" wrote ... Thanks not sure what I'm doing here so all info is appreciated! "David McRitchie" wrote: A13 A1: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) A26 A2: =OFFSET('Other Sheet'!A$13,(ROW()-1)*13,0) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Cell formatting behaviour question | Excel Discussion (Misc queries) | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |