Hi,

I have several spreadsheets that I need to increment a column each time information in another column changes. Using example below, each time program changes I need the count column to be incremented. I don't want to use autofill as I have to do this every month and several sheets with lots of rows.

Thanks for the help

Program Count
1100 1
1100 2
1100 3
1200 1
1200 2
1200
1200
1400
1400