Page 239 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

The nature of R1C1 references means that the exact same range string can be applied (using INDIRECT) against
all of the cells in G4:G7. With the A1 notation a different INDIRECT reference would be required for each row.
This example has been created to demonstrate INDIRECT() and R1C1 references. If I was trying to construct a
table like this with dynamic formulas I would probably use INDEX() or OFFSET() in preference to this method.

In the following (embedded web app) example you can edit the month number value in cell D3 and thereby
change the R1C1 string in cell F1. This string is used in each row in column G to supply the INDIRECT function
with a dynamic range.

R1C1 references are most useful when writing Visual Basic code. If you wish to use VBA to write cell formulas,
it is much easier to write code to increment 1, 2, 3 rather than A, B, C. Also, a single R1C1 formula with relative
references can be copied (using VBA) to a range of cells and will adjust to the appropriate rows and columns.

Named Ranges in Excel – An Introduction

How to Create Named Ranges in Excel

What’s in the name?
If you are working with Excel spreadsheets, it could mean a lot of time saving and efficiency.
If someone has to call me or refer to me, they will use my name (instead of saying a male is staying in so and so
place with so and so height and weight).
Right?
Similarly, in Excel, you can give a name to a cell or a range of cells.
Now, instead of using the cell reference (such as A1 or A1:A10), you can simply use the name that you assigned
to it.
For example, suppose you have a data set as shown below.

226

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77