CapnFirefly
New Member
- Joined
- Sep 10, 2014
- Messages
- 5
I have two spreadsheets, one with a Calendar, and the other one with Data Chart. I'm trying to make it so that the Data Chart will only start using Data from Today's date in the Calendar. (Note: Calendar has other things, like % work done, hours spent, etc). For that I'm trying to use the:
<code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: inherit; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;">=ADDRESS(MATCH(MAX(A1:A100);A1:A100;0);1;1;1;"")</code></pre>and infact I do get the address '!$A$88', but I cannot use this address because it has an exclamation mark in front of it. How do I use this address? Is there a way to remove this exclamation mark and start using this cell address in another formula, in a different spreadsheet?
PS. I will be using MATCH(TODAY()), not MAX()
<code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: inherit; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;">=ADDRESS(MATCH(MAX(A1:A100);A1:A100;0);1;1;1;"")</code></pre>and infact I do get the address '!$A$88', but I cannot use this address because it has an exclamation mark in front of it. How do I use this address? Is there a way to remove this exclamation mark and start using this cell address in another formula, in a different spreadsheet?
PS. I will be using MATCH(TODAY()), not MAX()
