Based on your description There are two possible answers.

If you want to sum up quantities of products or such then take a look at
pivot tables. Place your cusor in the middle of your data and select Data -
Pivot Tables - Then follow the wizard. Place your Product descriptions in
the left hand column and the quantities in the center of the table.

If you just want to display the sheet as a hierarchy then take a look at
conditional formats. If the value of the cell equals the value of the cell
above it then format the font colour to be the same as the background colour.
It does not delete the contents of the cell it just makes the text
invisible...
--
HTH...

Jim Thomlinson


"comparini3000" wrote:

My company identifies products like this: #####-###-AAA, with specific
numbers taking the place of the # sign and specific letters taking the place
of the A. the 5-digit number identifies the type of product, the 3-digit
number identifies the specific model for the type of product, and the 3
letters identify where the part was made.

I have already split the product numbers into the three components, but I
want to remove any repetitions in cell values. To show a sort of a hierarchy.
I want to go from this:

__A__ _B__ _C_
12345|123|ABC
12345|123|SDE
12345|321|RSW
54321|098|CBA
54321|890|ABC


to this:
__A__ _B__ _C_
12345|123|ABC
| |SDE
|321|RSW
54321|098|CBA
|890|ABC

how would i do that? thanks!

comparini3000