I'm using Excel 2007 and would use EITHER excel function or VBA! :o) On Jan 27, 11:55 am, Paul Schreiner <schreiner_p...@att.net> wrote: > What version of Excel are you using (Excel 2007 has some additional options) > > Are you hoping for a "Excel Function" solution or a VBA solution? > > Paul > > ________________________________ > From: Ahleah1031 <jeannie.car...@chase.com> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Thu, January 27, 2011 11:28:48 AM > Subject: $$Excel-Macros$$ Help with nested Vlookup > > I have to count the number of claims based on status codes, but also, > group the counts based on whether the eff date and pymt dates match or > don't match and whether they have a pymt or not....So, the counts > would be listed by status, then broken out by 4 columns (dates match w/ > pymt), (dates don't match w/pymts), (dates match w/out pymts) and > finally (dates don't match w/out pymts). > > I would greatly appreciate ANY guidance on a solution to this problem. > > Thank you in advance > > -- > ---------------------------------------------------------------------------------- > > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/discussexcel
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel