Matching Zipcodes

[Former Member]

Hi All,

I have a list of clients listed by their zipcodes and account open date (from 2002 to 2008), and I have another list of zipcodes that is on a spreadsheet titled "Western Region."

How do I create a formula so CRXI can count the number of clients with zipcodes that matches the spreadsheet "Western Region, AND with an account open date in 2008?"

Thank You!!

Frank

Edited by: CRXI Newb on May 13, 2009 8:47 PM

[Former Member]

Try to link your table with the spread sheet table with zipcode field and get the count by applying fielter condition for the field year=2008.

Regards,

Raghavendra