That will work, now I just have to figure out how to get that formula modified too fit my sheet. I have 192595 rows, and columns thru EH when I make the pivot table.