Formulas and Functions
ଏହି କଣ୍ଟ‍୍ରୋଲ୍‌କୁ ପରିବର୍ତ୍ତନ କରିବା ଫଳରେ ଏହି ପୃଷ୍ଠା ସ୍ବୟଂଚାଳିତ ଭାବରେ ଅପ୍‌ଡେଟ୍ ହୋଇଯିବ

REFERENCE.NAME

The REFERENCE.NAME function returns a string representation of the given cell reference.

REFERENCE.NAME(reference, reference-specificity, reference-style)

reference: An optional cell reference. The referenced cell can contain any value, or be empty. If reference is omitted, the cell containing the formula is used.

reference-specificity: An optional modal value that determines the amount of information to return in the string.

cell (0 or omitted): Return only the cell address.

table (1): Return the table name and cell address.

all (2): Return the sheet name or slide number; table name; and cell address.

reference-style: An optional modal value that determines the naming style of the returned string.

header-names (0 or omitted): Return the header names representing the cell reference if applicable.

A1 (1): Return the cell in the A1 form.

Notes

  • If REFERENCE.NAME is used in a header cell, reference-style defaults to A1, even if header-names is selected.

  • If categories or filters are added to a table, REFERENCE.NAME keeps the original cell references, so the returned string isn’t affected. This allows REFERENCE.NAME to be used with functions such as INDIRECT.

Examples

Let column B’s header name be "December", row 2’s header name be "Sales", and B3 be "B2".

=REFERENCE.NAME(B2) returns "December Sales".

=REFERENCE.NAME(B2, 2) returns "Sheet 1::Table 1::December Sales".

=REFERENCE.NAME(B) returns "December".

=REFERENCE.NAME(INDIRECT(B3)) returns "December Sales".

See alsoINDIRECT
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
ସହାୟକ କି?
କ‍୍ୟାରେକ୍ଟର୍ ସୀମା: 250
ସର୍ବାଧିକ କ‍୍ୟାରେକ୍ଟର୍ ସୀମା 250 ଅଟେ।
ଆପଣଙ୍କ ମତାମତ ପାଇଁ ଧନ‍୍ୟବାଦ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.