Actually, I may have spoken incorrectly about what I was trying to do. Column B is not populated, I want that column to be populated with a formula that will then populate the field the way it looks in the example. For instance, Group 111 has 4 lines, I want column B to count those rows but not as a total. Line one of that group should be 1, line 2 of that group should be 2 etc. Then the count starts at 1 again when there is a new group. I hope that helps.