Naredba /tj F-ja/ koja daje opciju za ime radnog lista je ADDRESS() - formira adresu ćelije po pravilima (tako da ne moraš da ih pamtiš) ali je rezultat običan tekst, tako da ga je potrebno proslediti ga INDIRECT(), da bi očitao vrednost na konkretnoj adresi.
Recimo, jedan primer za proizvoljnu adresu B10, s nazivom radnog lista u A1:
Code:
=INDIRECT(ADDRESS(ROW(B10);COLUMN(B10);4;1;A1))
Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!