Sorry, I have now found the group file section and will use it myself. Stephen, your problem amused me so much I wrote a new QFunction 'QSplit' that does the job. The file I am about to upload is called:
manos_w_QSplit.xls It takes the following arguments: QString([ArrayIn],[HeaderIncl],[SplitCols...]) [ArrayIn]: (required) is usually a reference to a continuous range on an Excel worksheet. It can also accept a function that returns an 'array' (such as qx - see my separate posting on this function), if this array is formatted like the database. You probably won't need to worry about this functionality. [HeaderIncl]: (required) Is a boolean TRUE or FALSE (or an expression returning TRUE or FALSE) which indicates whether the range or array provided in the argument ArrayIn contains a 'header' row. [SplitCols...]: (optional paramter array) Any arguments entered after the argument HeaderIncl should be references to the columns which are to be 'split' - ie, at most 1 should be included in this column. Arguments provided for SplitCols can be simple numeric inputs or references to cells not included in ArrayIn containing numeric inputs. The numeric input is in this case interpreted as the column of ArrayIn that contains quantities to be split (the columns are indexed from the left most column in ArrayIn starting with 1). Note the contents of arguments provided for SplitCols that are references to cells included in ArrayIn are not interpreted as column indexes. References to cells included in ArrayIn are instead interpreted as pointers to columns that contain quantities to be split (the difference is made clear in the example I've uploaded) Of course, only 'quantity' columns should be specified among 'SplitCols' arguments. If you were to specify a serial number column, and the serial numbers in question were to be entirely numeric, then QSplit would actually interpret the serial numbers as quantities adn give you many, many results. Note QSplit splits records into single unit rows until the remainder in any column specified in SplitCols is less than 1: thus if an unrounded quantity such as 2.2 were entered, QSplit would return two rows of quantity 1 and a last row of quantity 0.2. = Doug On Apr 13, 12:51 pm, Abhishek Jain <abhishek....@gmail.com> wrote: > Just to clarify, there is file in Group's file section. Have attached it > herewith. > > AJ > > On Tue, Apr 13, 2010 at 3:39 PM, Dougie Excel <douglaswilliamsm...@yahoo.com > > > > > wrote: > > As Paul Willekens said, you've not uploaded anything. > > > The easiest solution to your task *sounds* like it would be a pivot > > table (just google 'excel pivot tutorial' or something and you'll find > > out all you need). > > > The QX Function* can summarize databases on unique criteria as well, > > but being a VBA based function it runs slower than pivot tables and > > probably offers alot of functionality you don't need. > > > On Apr 12, 7:12 pm, Stephen Manos <stephen.ma...@qwest.com> wrote: > > > I'm not sure of the term to use for what I want to do. I have 412 rows > > > summarizing the number of pieces of different equipment at a given > > > place. I need to put each piece of equipment on a distinct row. I have > > > uploaded a file manos_sample_data that shows a FROM & TO sample. Can > > > anyone assist with how to phrase this and/or a solution? Thank you. > > > *www.douglaswilliamsmith.net/Excel_Functions > > > -- > > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our Facebook Group @ > >http://www.facebook.com/group.php?gid=287779555678 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 6,800 subscribers worldwide and receive many nice notes about > > the learning and support from the group.Let friends and co-workers know they > > can subscribe to group at > >http://groups.google.com/group/excel-macros/subscribe > > > To unsubscribe, reply using "remove me" as the subject. > > > > manos_sample_data.xls > 24KViewDownload- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
