Re: $$Excel-Macros$$ Re: Convert to unique rows

2010-04-14 Thread Stephen Manos
412,TRUE,1,2,3,4,5), then CTRL+SHIFT+ENTER and it has propogated all data to a unique row. Cross-checking sample for departure. I cannot thank you enough Doug! sm On Apr 14, 10:20 am, Stephen Manos wrote: > Thank you very much, Doug, this looks amazing. I am singing praises to > you. I will in

Re: $$Excel-Macros$$ Re: Convert to unique rows

2010-04-14 Thread Stephen Manos
> > 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 p

Re: $$Excel-Macros$$ Re: Convert to unique rows

2010-04-14 Thread Stephen Manos
Thank you very much, Doug, this looks amazing. I am singing praises to you. I will incorporate into my actual data. Thank you very much for taking the time On Apr 13, 9:57 am, Dougie Excel wrote: > Sorry, I have now found the group file section and will use it myself. > > Stephen, your problem am

$$Excel-Macros$$ Convert to unique rows

2010-04-12 Thread Stephen Manos
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 ho