Advanced Filtering.....
I have a huge worksheet, consisting of codes in Column A, a product name in
Column B and a cost price of the item in Column C. Each product some times
appears more than once as they may have more than one cost price.
How do I filter the list so it will only show me one record of each product
rather than several, depending on the number of cost prices each item has?
Hope this makes sense??
Thank you.
Louise
|