I have a small issue with Excel. I doing transformations for some columns in the dataset. I know the number of the columns I want, but I wasn't able to use them in a formula. For example I want to add the 5th and the 10th column. How do I write this formula?
Note: I have tried the R1C1 reference style but it is not what I am looking for.