='Tabl.1&3 Cohorts'!C70

  • Thread starter Thread starter Guest
  • Start date Start date
It's the separator that excel uses between the worksheet name (Tabl.1&3 Cohorts)
and the address of the cell (C70).
 
A 3-D cell reference includes the worksheet name, an exclamation point (!),
and the cell or cells referenced. The exclamation point is just the symbol
used as a seperator between the worksheet name and the cell address.
 
It identifies the text between the = sign and the ! as the sheet name.

Or, the sheet name identifier.

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a forumula to many cells -but keeping one element static 2
How to make unbound combo box select all if related query record is null 1
calculating incremental value contingent on other field 1
Counta function 3
retrieve peer data 3
Selecting value contingent on other field 1
DLookUp 1
SUMPRODUCT Problem 1

Back
Top