I have a spreadsheet that includes 500 rows and 15 columns. The data includes
Name, Address, Phone per column and 2 columns of effective dates, one for
each contract. I am trying to create a report that will give me the name of
each individual where each contract expires in a given month. I have formated
the columns to show months only. have tried Filter and Pivot but neither
work. I need an "AND" solution.

ANy help would be appreciated.

Jim