you can try pivot table or power pivot On Sat, Oct 10, 2015 at 6:03 PM, Greg Della-Croce <greg_della-cr...@sil.org> 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 have a table with just shy of 50,000 rows that looks something like this: > > Key1 Key2 MinDate MaxDate TotalItems > A 1 10/1/2010 4/2/2011 12 > B 4 03/1/2009 09/10/2014 52 > C 24 01/2/2015 4/17/2015 08 > B 4 02/15/2008 06/03/2012 10 > > I need to summarize this down to: > Key1 Key2 MinDate MaxDate TotalItems > A 1 10/1/2010 4/2/2011 12 > B 4 02/15/208 09/10/2014 62 > C 24 01/2/2015 4/17/2015 08 > > > I just can't see how to do this without reading all 50,000 rows 50,000 > times since VLookup will not return multiple records using a compound key. > Add to that I don't remember the process for reading each record in a > table and stopping at the end of the table. (Can you say it has been a > looong time since I wrote VBA code like this?) > > Is there a kind soul out there that can push me in the correct direction > with some suggestions? > > Thanks to everyone who takes the time to reply ahead of time! I do > appreciate it. > > GregDC > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook <https://www.facebook.com/excelvbacodes> Join Us on Facebook <http://www.facebook.com/groups/163491717053198/> P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
