A
AJ
I have a column that contains product codes. Each product code may have
several rows of data but the product code stays constant from row to row
within the group. Is there a way that I can do a vlookup to only pick up the
product code only once from each group? (The product codes can vary from
month to month so I don't want to hard code anything.)
Example:
A008
A008
A008
A008
A010
A010
A010
A012
A013
A013
A Total
I would like to pull A008, A010, A012, A013 & A Total,......
Any help would be appreciated.
several rows of data but the product code stays constant from row to row
within the group. Is there a way that I can do a vlookup to only pick up the
product code only once from each group? (The product codes can vary from
month to month so I don't want to hard code anything.)
Example:
A008
A008
A008
A008
A010
A010
A010
A012
A013
A013
A Total
I would like to pull A008, A010, A012, A013 & A Total,......
Any help would be appreciated.