Re: $$Excel-Macros$$ How to do a summary of a large table

2015-10-13 Thread Greg Della-Croce
Paul, I played with your suggestion and now have a working/MacGyver'ed together solution that will allow me to do my report. Thanks. I have used that method before, I just had not thought to use it here.I appreciate your offer to write the macro, but I was stubborn and worked it out

Re: $$Excel-Macros$$ How to do a summary of a large table

2015-10-10 Thread Paul Schreiner
There's several ways to manage this.It LOOKS like you are identifying all unique Key1/Key2 combinations.then, recording the minimum mindate and maximum maxdate and totaling the totalitems. copy Key1,Key2 to another set of columns and remove duplicates.combine key1 "." key2 to create a "key" fiel

Re: $$Excel-Macros$$ How to do a summary of a large table

2015-10-10 Thread ashish koul
you can try pivot table or power pivot On Sat, Oct 10, 2015 at 6:03 PM, Greg Della-Croce wrote: > Since I do no see a way to do this with just functions, I think I am going > to have to write some code to do this myself, but I would appreciate a word > from the experts (aka you people) > > I hav