| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
address
Hi all
How do I turn ='Tour managers Spreadsheet'!A10 Into ='Tour managers Spreadsheet'! and for the cell "A"&(ROW()/2*4+2)+4 Question is how do I attach the two parts of the Formula Thanks Stew |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
address
=INDIRECT('Tour managers Spreadsheet'!A"&(ROW()/2*4+2)+4)
Note that your math operations at the end simplify to =INDIRECT('Tour managers Spreadsheet'!A"&(ROW()*2+6)) However, if you want the value of cell A & ROW(), and then want to perform math operations =INDIRECT('Tour managers Spreadsheet'!A"&ROW())*2+6 Does this answer your question? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "stew" wrote: Hi all How do I turn ='Tour managers Spreadsheet'!A10 Into ='Tour managers Spreadsheet'! and for the cell "A"&(ROW()/2*4+2)+4 Question is how do I attach the two parts of the Formula Thanks Stew |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
address
Hi Luke
Can't seem to make any of thes work . Will not accept as a Formula Any Thoughts Stew "Luke M" wrote: =INDIRECT('Tour managers Spreadsheet'!A"&(ROW()/2*4+2)+4) Note that your math operations at the end simplify to =INDIRECT('Tour managers Spreadsheet'!A"&(ROW()*2+6)) However, if you want the value of cell A & ROW(), and then want to perform math operations =INDIRECT('Tour managers Spreadsheet'!A"&ROW())*2+6 Does this answer your question? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "stew" wrote: Hi all How do I turn ='Tour managers Spreadsheet'!A10 Into ='Tour managers Spreadsheet'! and for the cell "A"&(ROW()/2*4+2)+4 Question is how do I attach the two parts of the Formula Thanks Stew |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
address
Argh! I left out opening quotation mark.
=INDIRECT("'Tour managers Spreadsheet'!A"&(ROW()*2+6)) or =INDIRECT("'Tour managers Spreadsheet'!A"&ROW())*2+6 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "stew" wrote: Hi Luke Can't seem to make any of thes work . Will not accept as a Formula Any Thoughts Stew "Luke M" wrote: =INDIRECT('Tour managers Spreadsheet'!A"&(ROW()/2*4+2)+4) Note that your math operations at the end simplify to =INDIRECT('Tour managers Spreadsheet'!A"&(ROW()*2+6)) However, if you want the value of cell A & ROW(), and then want to perform math operations =INDIRECT('Tour managers Spreadsheet'!A"&ROW())*2+6 Does this answer your question? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "stew" wrote: Hi all How do I turn ='Tour managers Spreadsheet'!A10 Into ='Tour managers Spreadsheet'! and for the cell "A"&(ROW()/2*4+2)+4 Question is how do I attach the two parts of the Formula Thanks Stew |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
address
Hi Luke
Yes This now works . Thank you. However I have found an irregularity in the layout in that This Formula Picks out every second Line from the "Tour managers spread sheet " but on line 110 the next line we want is 113 and regular every two lines after(115,117,119 etc) until 213 and then we want 216(218,220,222 etc) and onwards. In other words every 103 line the requirement shifts!! Can you adapt to suit? Best Stewart "Luke M" wrote: Argh! I left out opening quotation mark. =INDIRECT("'Tour managers Spreadsheet'!A"&(ROW()*2+6)) or =INDIRECT("'Tour managers Spreadsheet'!A"&ROW())*2+6 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "stew" wrote: Hi Luke Can't seem to make any of thes work . Will not accept as a Formula Any Thoughts Stew "Luke M" wrote: =INDIRECT('Tour managers Spreadsheet'!A"&(ROW()/2*4+2)+4) Note that your math operations at the end simplify to =INDIRECT('Tour managers Spreadsheet'!A"&(ROW()*2+6)) However, if you want the value of cell A & ROW(), and then want to perform math operations =INDIRECT('Tour managers Spreadsheet'!A"&ROW())*2+6 Does this answer your question? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "stew" wrote: Hi all How do I turn ='Tour managers Spreadsheet'!A10 Into ='Tour managers Spreadsheet'! and for the cell "A"&(ROW()/2*4+2)+4 Question is how do I attach the two parts of the Formula Thanks Stew |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
address
So you may want to experiment with a term like ROW()*2+6+INT((ROW()-2)/51) ?
-- David Biddulph "stew" wrote in message ... Hi Luke Yes This now works . Thank you. However I have found an irregularity in the layout in that This Formula Picks out every second Line from the "Tour managers spread sheet " but on line 110 the next line we want is 113 and regular every two lines after(115,117,119 etc) until 213 and then we want 216(218,220,222 etc) and onwards. In other words every 103 line the requirement shifts!! Can you adapt to suit? Best Stewart "Luke M" wrote: Argh! I left out opening quotation mark. =INDIRECT("'Tour managers Spreadsheet'!A"&(ROW()*2+6)) or =INDIRECT("'Tour managers Spreadsheet'!A"&ROW())*2+6 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "stew" wrote: Hi Luke Can't seem to make any of thes work . Will not accept as a Formula Any Thoughts Stew "Luke M" wrote: =INDIRECT('Tour managers Spreadsheet'!A"&(ROW()/2*4+2)+4) Note that your math operations at the end simplify to =INDIRECT('Tour managers Spreadsheet'!A"&(ROW()*2+6)) However, if you want the value of cell A & ROW(), and then want to perform math operations =INDIRECT('Tour managers Spreadsheet'!A"&ROW())*2+6 Does this answer your question? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "stew" wrote: Hi all How do I turn ='Tour managers Spreadsheet'!A10 Into ='Tour managers Spreadsheet'! and for the cell "A"&(ROW()/2*4+2)+4 Question is how do I attach the two parts of the Formula Thanks Stew |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
address
Hi Luke and David
My problem is solved thanks to your attention Thanks again Stew "David Biddulph" wrote: So you may want to experiment with a term like ROW()*2+6+INT((ROW()-2)/51) ? -- David Biddulph "stew" wrote in message ... Hi Luke Yes This now works . Thank you. However I have found an irregularity in the layout in that This Formula Picks out every second Line from the "Tour managers spread sheet " but on line 110 the next line we want is 113 and regular every two lines after(115,117,119 etc) until 213 and then we want 216(218,220,222 etc) and onwards. In other words every 103 line the requirement shifts!! Can you adapt to suit? Best Stewart "Luke M" wrote: Argh! I left out opening quotation mark. =INDIRECT("'Tour managers Spreadsheet'!A"&(ROW()*2+6)) or =INDIRECT("'Tour managers Spreadsheet'!A"&ROW())*2+6 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "stew" wrote: Hi Luke Can't seem to make any of thes work . Will not accept as a Formula Any Thoughts Stew "Luke M" wrote: =INDIRECT('Tour managers Spreadsheet'!A"&(ROW()/2*4+2)+4) Note that your math operations at the end simplify to =INDIRECT('Tour managers Spreadsheet'!A"&(ROW()*2+6)) However, if you want the value of cell A & ROW(), and then want to perform math operations =INDIRECT('Tour managers Spreadsheet'!A"&ROW())*2+6 Does this answer your question? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "stew" wrote: Hi all How do I turn ='Tour managers Spreadsheet'!A10 Into ='Tour managers Spreadsheet'! and for the cell "A"&(ROW()/2*4+2)+4 Question is how do I attach the two parts of the Formula Thanks Stew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a range address with ADDRESS function? | Excel Worksheet Functions | |||
| How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
| long address list, name-address-city, listed vertically, how do y. | Excel Discussion (Misc queries) | |||
| How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
| Using =address to provide address location for =average | Excel Worksheet Functions | |||
Linear Mode
