Learning to Use the Address Formula
An Excel file that teaches how to perform Learning to Use the Address Formula operation.
Excel Solution: Learning to Use the Address Formula
Row and column numbers are given as parameters. Absolute and relative references are being tried. The output is used with other functions. Dynamic range creation examples are provided.
Hope it is useful.