Quantcast

named data ranges

classic Classic list List threaded Threaded
1 message Options
Gary Collins Gary Collins
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

named data ranges

Hello again
I appear to be experiencing a problem with named data ranges lo 5.2.2.2 x64 win 7.

Q. Is it possible and permissible to define overlapping data ranges? I want a range named mdec which will be A1:B25 and another xlit B1:C25 (the col B values are common) to use in lookups.

I have set them up and they appear ok in the Define Database Range dialog. However, when i try to enter xlit as the range in a formula i find that it automatically gets changed to mdec.

Im going now to try with the ranges defined explicitly instead of using the names, but i wonder if this problem sounds at all familiar to anyone, and if theres anything i can do about it?

Thanks
Gary

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Loading...