Excel Count the Number of Consecutive Cells
Posted on 2011-10-05
In a spreadsheet, Column B has ID #'s. The ID #'s can appear once, or repeat numerous times down the column until the next ID appears. I would like to create a new column C that will calculate the number of times each ID appears in Column B, next to the ID itself. For example, if ID 2356 appears in rows 13, 14, 15, 16, in Column B, then in Column C, there would be a 4 next to each of the ID's in these rows.
Hope this made sense.