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
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
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