View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
eyespike1 eyespike1 is offline
external usenet poster
 
Posts: 2
Default Comparing Multiple fields

I am attempting to compare the ROUNDOPENDATE to the OpenDate.
If any Name1 has any ROUNDOPENDATE and that matches any Name1 OpenDate then
list which product matches. In the following example Name1 product would be
ATM and Name2 would be ATM and USavings.
If I could programically fill the proper ROUNDOPENDATE for each product that
doesn't have an ROUNDOPENDATE, then i could easily compare the dates. But
there are 35K rows.

Name1 OpenDate ROUNDOPENDATE Product
Name1 03/17/1999 02/15/2007 Classic Account
Name1 02/15/2007 ATM
Name1 02/15/2007 USavings
Name2 02/14/2009 02/14/2009 MChecking
Name2 02/14/2009 ATM
Name2 02/14/2009 USavings
Name3 11/20/1997 USavings
Name4 07/28/2003 Simply Free
Name4 10/16/2009 ATM
Name4 05/15/2009 05/15/2009 MSavings
Name5 02/19/2008 05/14/2009 Bonus Checking
Name6 08/21/2009 ATM
Name6 08/18/2009 ATM
Name6 08/17/2009 ATM
Name6 08/17/2009 MSavings
Name6 05/14/2009 USavings
Name7 07/24/2004 02/07/2007 Simply Free
Name7 11/22/2009 11/22/2009 Bonus Checking
Name7 12/01/2009 ATM
Name7 02/11/2009 ATM
Name7 07/26/2007 USavings
Name7 04/11/2002 USavings
Name8 01/30/2009 ATM
Name8 11/23/2004 Simply Free
Name8 11/23/2004 USavings
Name9 11/26/2007 11/26/2007 Simply Free
Name9 02/11/2009 ATM
Name9 11/26/2007 USavings
Name9 11/26/2007 USavings