I have values in cells
61A
61A
61A
61B
61B
61B
61C
61C
61C
I want to merge by*vba*61A in one group*
61B and 61C as well. These values might be different base on result.
It can be increased or decreased.
Can any one tell me code of*vba
I have values in cells
61A
61A
61A
61B
61B
61B
61C
61C
61C
I want to merge by*vba*61A in one group*
61B and 61C as well. These values might be different base on result.
It can be increased or decreased.
Can any one tell me code of*vba
A simple Pivot Table will do it for you
Since your shown data consist only single column, so in this case the Remove Duplicates will do it for you.
Use Macro Recorder and try Remove Duplicate method.
These are 9 cells and cells can be increased base on value.
You can put different values are same values in other columns. I need this first column to be merge. Select 61A and merge it to show single value with three cells in 2nd column but in vba.