Hi
Don't really know how to explain this.. I have a cell which I have referenced to another sheet, and the sequence goes like this: B1,K1,T1.. basically it skips every 9 letters.
I have done 1 column of this and I am attempting to sequence the formula for the next column as B46,K46,T46..
Basically what I want to do is add 45 to the cell ITSELF and not the cell VALUE (e.g. B1+45=B46 NOT B1+45=46 if B1=1)
How do I do this?
Much help would be appreciated.
Use INDEX...
You don't specify where you're putting these formulae but if we assume you have a table A1:C2 where A1:C1 contain B1,K1 & T1 from another sheet and A2:C2 contain B46,K46 and T46 etc... then:
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Are those actual text strings.. ie. B1, K1, T1 or are they cell refs.. as in =B1, =K1, =T1?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Sorry didnt make it clear. B1, K1, T1 etc are actual cell refs
Have you looked at DO's suggestion above?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks