Excel Error Must Contiguous Reference
Contents |
Forums Excel Questions what is input range must be contiguous reference Results 1 to 4 of 4 what is input range must be contiguous referenceThis is a discussion on what is input range must be
Excel Input Range Must Be A Contiguous Reference
contiguous reference within the Excel Questions forums, part of the Question Forums category; Never seen excel histogram input range must be a contiguous reference this before and not sure what I am doing wrong. I cannot find a reference to contiguous reference ... LinkBack LinkBack
Excel Error Print Titles Must Be Contiguous
URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Jan 23rd, 2003,11:31 excel error print titles must be contiguous and complete rows or columns AM #1 robafen New Member Join Date Jul 2002 Posts 24 Never seen this before and not sure what I am doing wrong. I cannot find a reference to contiguous reference in the Excel Help. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jan 23rd, 2003,11:51 AM #2 Mark W. MrExcel MVP Join Date Feb 2002 Location Austin, Texas USA Posts 11,654 Enter "contiguous" as the keyword excel error message print titles must be contiguous on the Help Index tab. If you can't see the Index tab click on the Show tool (leftmost position) on the Help dialog's command bar. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jan 23rd, 2003,11:55 AM #3 Seti Board Regular Join Date May 2002 Location CT Posts 2,915 This means that the selection must be a single cell or the selection must be a rectangular area, not multiple unconnected areas. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jul 6th, 2010,06:26 AM #4 TonyHold New Member Join Date Jul 2010 Posts 1 Re: what is input range must be contiguous reference I had the same problem trying to generate a Histogram. The solution I found to work was to copy the bin data onto the same worksheet as the sample data. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Like this thread? Share it with others Like this thread? Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] cod
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 13 Oct 2016 20:50:41 GMT by s_ac4 (squid/3.5.20)
2003. Andreas Guest Using the Data Analysis add-in, I'm trying to take a random sample of a batch of records. Unfortunately, using the Sampling tool, I keep http://www.pcreview.co.uk/threads/sampling-input-range-must-be-a-contiguous-reference.1740041/ getting the error message above. There is no documentation of what this means in the online help. Any idea what I can do to make this thing work? I really don't want to https://groups.google.com/d/topic/microsoft.public.excel.worksheet.functions/bAdepcTFxtY have to use the RANDBETWEEN function for a sample of this size. Thanks! Andreas Andreas, Jul 17, 2003 #1 Advertisements Anon Guest "Andreas" <> wrote in message news:0c7001c34c73$9573f360$... > Using the must be Data Analysis add-in, I'm trying to take a > random sample of a batch of records. Unfortunately, using > the Sampling tool, I keep getting the error message > above. There is no documentation of what this means in > the online help. Any idea what I can do to make this > thing work? I really don't want to have to use the print titles must > RANDBETWEEN function for a sample of this size. > > Thanks! > Andreas A1,A2,A3 or A1:B10 are contiguous ranges, whereas A1,A3,A5 or A1:A3,B4 are not. In simple language, the cells in the range must be next to each other, in a simple block. Anon, Jul 17, 2003 #2 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum. Sign Up Now! Your name or email address: Do you already have an account? No, create an account now. Yes, my password is: Forgot your password? Stay logged in Welcome to PC Review! Hello and welcome to PC Review. We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions. Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. You'll be able to ask any tech support questions, or chat with the community and help others. Sign up no
von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen