Sunday, July 12, 2009

In Excel R[1]C[1] referencing mode, is there a way to use variables or operations? Like R(2*5)C(1) or R(x)C?

Thanks!!

In Excel R[1]C[1] referencing mode, is there a way to use variables or operations? Like R(2*5)C(1) or R(x)C?
=INDEX(1:65536,2*5,2+4)





2*5 will result in row 10, and 2+4 will result in column 6


No comments:

Post a Comment