View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AJ[_4_] AJ[_4_] is offline
external usenet poster
 
Posts: 14
Default Find first entry in a column

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