rjacmuto32
Member
Thanks for the help. Both files worked.
One thing i noticed is when I was using the table, even though I'm in Excel 2007 the file was a .xls file and said Compatitabiliy Mode at the top. The pivot table options are grayed out for contains. I converted the file to .xlsx and the options became available to do contains. I used the codes listed above and both ways worked.
One thing i noticed is when I was using the table, even though I'm in Excel 2007 the file was a .xls file and said Compatitabiliy Mode at the top. The pivot table options are grayed out for contains. I converted the file to .xlsx and the options became available to do contains. I used the codes listed above and both ways worked.