R1C1 formula question
I want to create a formula that will at cell R1C1. However, the C1 part needs
to be variable. Here is the example of what i think it should be: =R1C" & B2 & " this formula needs to return Row1 and column number whosw the value located in the cell B2. Lets say B2 has a number 70 in it. The result of the formula i need to return is the value located in R1C70 Please help, because my brains are exploding |
R1C1 formula question
One way:
=index(1:1,b2) Another: =indirect("r1c"&B2,false) The top one will only recalc when required. The second one will recalc whenever excel recalcs. igorek wrote: I want to create a formula that will at cell R1C1. However, the C1 part needs to be variable. Here is the example of what i think it should be: =R1C" & B2 & " this formula needs to return Row1 and column number whosw the value located in the cell B2. Lets say B2 has a number 70 in it. The result of the formula i need to return is the value located in R1C70 Please help, because my brains are exploding -- Dave Peterson |
R1C1 formula question
hi
R1C1 is not a formula. It is a reference style. It is how excel realy see the sheet layout in the background. we see it as cell B2. excel programming convert this to R2C2. It's more like an address. you can't split it up nor use it like a regular formula. see on the menu bar...toolsoptionsgeneral tabcheck R1C1 reference style. all of your column letter are now column numbers. sorry regards FSt1 "igorek" wrote: I want to create a formula that will at cell R1C1. However, the C1 part needs to be variable. Here is the example of what i think it should be: =R1C" & B2 & " this formula needs to return Row1 and column number whosw the value located in the cell B2. Lets say B2 has a number 70 in it. The result of the formula i need to return is the value located in R1C70 Please help, because my brains are exploding |
All times are GMT +1. The time now is 01:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com