Hi, I was wondering whether anyone can help me with this?
I am trying to merge rows of data according to column A and count the non-zero cells in column B, then delete duplicates in A. An example is below.
A B
0 0
0 536
0 0
1 5687
1 6459
1 0
2 0
2 0
3 6893
3 67489
3 1247
I would like it to become:
A B
0 1
1 2
2 0
3 3
I have mulitple sheets in the workbook and therefore would like it in macro.
Can anyone help?
Thanks!
I am trying to merge rows of data according to column A and count the non-zero cells in column B, then delete duplicates in A. An example is below.
A B
0 0
0 536
0 0
1 5687
1 6459
1 0
2 0
2 0
3 6893
3 67489
3 1247
I would like it to become:
A B
0 1
1 2
2 0
3 3
I have mulitple sheets in the workbook and therefore would like it in macro.
Can anyone help?
Thanks!