| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insertion of a cell address that constantly rises by a set number
I have a large spread sheet I am working on and I wish to increase a cell
address by 103 every time ie =L103,= L206,=L309 ETC Is there a formula that will increase this address thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insertion of a cell address that constantly rises by a set number
On Aug 24, 8:50 pm, stew wrote:
I have a large spread sheet I am working on and I wish to increase a cell address by 103 every time ie =L103,= L206,=L309 ETC Is there a formula that will increase this address thank you Maybe... =IF(INDIRECT("L"&103*ROWS($1:1))="","",INDIRECT("L "&103*ROWS($1:1))) Ken Jhnson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insertion of a cell address that constantly rises by a set num
Dear Ken,
I am not explaining my self enough ='Road Cash Accounting'!I318 in this formula, when I cut and paste, the I318 SHOULD BECOME I421. What if anything can I add to this Formula to achieve that. Thanks Stew "Ken Johnson" wrote: On Aug 24, 8:50 pm, stew wrote: I have a large spread sheet I am working on and I wish to increase a cell address by 103 every time ie =L103,= L206,=L309 ETC Is there a formula that will increase this address thank you Maybe... =IF(INDIRECT("L"&103*ROWS($1:1))="","",INDIRECT("L "&103*ROWS($1:1))) Ken Jhnson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insertion of a cell address that constantly rises by a set num
Don't use Cut use Copy and the reference should change automatically.
-- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "stew" wrote in message ... Dear Ken, I am not explaining my self enough ='Road Cash Accounting'!I318 in this formula, when I cut and paste, the I318 SHOULD BECOME I421. What if anything can I add to this Formula to achieve that. Thanks Stew "Ken Johnson" wrote: On Aug 24, 8:50 pm, stew wrote: I have a large spread sheet I am working on and I wish to increase a cell address by 103 every time ie =L103,= L206,=L309 ETC Is there a formula that will increase this address thank you Maybe... =IF(INDIRECT("L"&103*ROWS($1:1))="","",INDIRECT("L "&103*ROWS($1:1))) Ken Jhnson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insertion of a cell address that constantly rises by a set num
If by *Adjacent* you mean next cell down then with the *starting* formula
=Sheet1!I318 in A5 then in A6 use: =OFFSET(Sheet1!$I$318,103*(ROW()-ROW($A$5)),0) and copy down. If by *adjacent* you mean next cell to the right then use COLUMN() in place of ROW() and adjust as necessary. Stew On a Island of the coast of Scotland And you're working on a SUNDAY????? <G -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "stew" wrote in message ... iF i DO THAT AND PASTE TO ADJACENT CELL IT BECOMES ='Road Cash Accounting'!J318. i NEED IT TO INCREASE BY 103 EVERY TIME I.E.='Road Cash Accounting'!I421 ='Road Cash Accounting'!I524 ='Road Cash Accounting'!I627 Stew On a Island of the coast of Scotland Scotland "Sandy Mann" wrote: Don't use Cut use Copy and the reference should change automatically. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "stew" wrote in message ... Dear Ken, I am not explaining my self enough ='Road Cash Accounting'!I318 in this formula, when I cut and paste, the I318 SHOULD BECOME I421. What if anything can I add to this Formula to achieve that. Thanks Stew "Ken Johnson" wrote: On Aug 24, 8:50 pm, stew wrote: I have a large spread sheet I am working on and I wish to increase a cell address by 103 every time ie =L103,= L206,=L309 ETC Is there a formula that will increase this address thank you Maybe... =IF(INDIRECT("L"&103*ROWS($1:1))="","",INDIRECT("L "&103*ROWS($1:1))) Ken Jhnson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insertion of a cell address that constantly rises by a set number
Dear Sandy
Thank You. I have now Modified the Formula with a new understanding and it is doing all that is required I cannot thank you enough for this act of unpaid Generousity Thank You Stew "stew" wrote: I have a large spread sheet I am working on and I wish to increase a cell address by 103 every time ie =L103,= L206,=L309 ETC Is there a formula that will increase this address thank you |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insertion of a cell address that constantly rises by a set number
You are very welcome and your thanks is payment enough.
-- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "stew" wrote in message ... Dear Sandy Thank You. I have now Modified the Formula with a new understanding and it is doing all that is required I cannot thank you enough for this act of unpaid Generousity Thank You Stew "stew" wrote: I have a large spread sheet I am working on and I wish to increase a cell address by 103 every time ie =L103,= L206,=L309 ETC Is there a formula that will increase this address thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i remove a constantly appearing % in a cell in excel? | Excel Discussion (Misc queries) | |||
| Auto column insertion based on a number | Excel Worksheet Functions | |||
| Auto row insertion based on a number | Excel Worksheet Functions | |||
| automatic multiple insertion of 0 infront of a tel number? | Excel Discussion (Misc queries) | |||
| VB Random Number Generation/Insertion/NextWorksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
