I am trying to get a grouping on a product code and didn't know if I could
set up a formula that would search the column and only return the value once.
The product codes can change from month to month with new ones being added
(and old ones removed.) Here is my example (the number of product codes can
be lengthy):

A
1 A008
2 A008
3 A010
4 A012
5 A012
6 A013
7 A013
8 A013

I would like to put a formula in another spreadsheet that would return the
following:

A
1 A008
2 A010
3 A012
4 A013

Any help would be appreciated.

--
AJ

The easiest way to do this is to use the advanced filter and filter on
unique records only and copy to another location

--
Biff
Microsoft Excel MVP


"AJ" wrote in message
...
I am trying to get a grouping on a product code and didn't know if I could
set up a formula that would search the column and only return the value
once.
The product codes can change from month to month with new ones being added
(and old ones removed.) Here is my example (the number of product codes
can
be lengthy):

A
1 A008
2 A008
3 A010
4 A012
5 A012
6 A013
7 A013
8 A013

I would like to put a formula in another spreadsheet that would return the
following:

A
1 A008
2 A010
3 A012
4 A013

Any help would be appreciated.

--
AJ