Dynamic Chart - Offset function
Good morning,
I'm using the attached file for my cash flow...but my offset functions are giving me a #Value.
Everything works but, I can't simply figure out what is causing this result.
Can someone please be kind enough to point me out in the right direction?
Thank you,
Antonio
Last edited by jantonio; 10-17-2011 at 02:50 PM.
The offset function on the sheet will not return any values unless you enter as array, Control+Shift+Enter. Plus you will need to select multiple rows if you want to see more than the first value.
Why do you need to see the answers on the worksheet?
Thank you...no particular reason to see the answers on the sheet.
Just returning back home from a sick weekend...should have known better that it due to a array formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks