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