So i have a document with an array formula in it and i cannot seem to get it to work. It actually works for the first 60 records or so but not all of them.
I have attached a sample document. the summary sheet and referral specifics sheet are not completing the formulas. It is making it to "L" and stopping there.
I am sure it is a simple solution but i have been staring at it all day!!!
Thanks LOS
you need to extend your Referral data length
'Referral Data'!$B$3:$B$102
make it up to 205
ie
Formula:
Please Login or Register to view this content.
Last edited by humdingaling; 11-17-2014 at 10:36 PM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Fixed it thank you!!!
not a problem
may want to look into using named range for your formulas
that way next time you need to amend the data you can do so in one place instead of every single formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks