Find first entry in a column

A

AJ

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.
 
T

T. Valko

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