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