Here's the set of data I am struggling with:
Column A Column B
12345 1
12345 2
12345 3
12345 1
12345 2
12345 3
12346 1
12346 2
12346 1
12346 2
Am trying to write a formula that would count duplicate records in column B for the group of records in Column A. For e.g. for record 12345 in column A, 1 in column B gets repeated twice and so on and so forth or in other words, for record 12345 in column A, group 1,2,3 in column B gets repeated twice.
Is there a formula that would help me derive that? Pleasseee help, have been struggling with this since last two days and finally need to pick your excel brains on this.
Thank You.
Parekh
Bookmarks