First thanks for your time!
second i've searched and can't seem to find what i'm looking for. i want to merge cells in a column but have it count how many cells are similar, then modify 1 cell and delete the rest.
Example
Part number | Part Name
1234 | part a
1999 | part b
1234 | part a
1234 | part a
8765 | part c
my goal is
Part Number | Part name
1234 x 3 | part a
1999 | part b
8765 | part c
basically i want excel to remove the duplicate cells and put a X? for the amount removed.
I can't find the info anywhere.
thanks a million!
Bookmarks