Retrieving unique values in excel
Posted on 2011-09-15
I have a mailing list of 20,000 records on an excel spreadsheet, I am using Excel 2003.
Here is a sample of my recordset.
Column A Column B Column C
John Smith 205 Broad St.,NYC Product ABC
Mary Jones 123 Main St., NYC Product ABC
Mary Jones 123 Main St., NYC Product XYZ
Stan Smith 132 Main St., NYC Product XYZ
I want to have my list to show only customers who are only ordering one product, i.e. only John Smith and Stan Smith so we can mail their product out right away.
I have experimented with advanced filtering with no luck.