LinkBack URL
About LinkBacks
Hi,
i have created a Named Range, and entered the following formula in "Refers To:"
=offset(Customers!$C$6,,,Counta(Customers!$C$6:$C$103),6)
the formula is rejected ??
I am using 2010
any help would be appreciated
Thank you in advance!
Hi,
i have created a Named Range, and entered the following formula in "Refers To:"
=offset(Customers!$C$6,,,Counta(Customers!$C$6:$C$103),6)
the formula is rejected ??
I am using 2010
any help would be appreciated
Thank you in advance!
Hi.
What message did Excel give you? Was it not perhaps rather related to the name that you chose than to the actual formula, which appears perfectly fine to me.
Regards
Can you elaborate on "rejected" ?
What exactly happens when you click OK after entering the formula in the "Refers To:" Box?
it pops up with a message BOX saying "WE HAVE A PROBLEM WITH THIS FORMULA" and then elaborates ..."WHEN USING '=' EXCEL THINKS ITS A FORMULA, TRY USING AN APOSTROPHE BEFORE "
Last edited by Tracyd2475; 03-12-2015 at 09:23 AM. Reason: additional info
Well, there's nothing wrong with the formula you posted.
I can only suggest to make sure the 'Refers To:' box is completely empty first before entering that formula.
Make sure you enter the formula EXACTLY as you posted it.
Any syntax errors in the formulua (like extra/missing parens or commas) would result in an error like the one you're getting.
Perhaps your regional settings have ; as the list seperator instead of a comma.
Try
=offset(Customers!$C$6;;;Counta(Customers!$C$6:$C$103);6)
that was the problem!
THANK YOU VERY MUCH!
been stuck on this for hours before posting.........
Much appreciated!!!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks