list unique values in a list

  • Thread starter Thread starter bobby769
  • Start date Start date
B

bobby769

I have a list of vendor names with some names repeated.
How do I get a listing of all vendor names?
 
I have a list of vendor names with some names repeated.
How do I get a listing of all vendor names?
Click to expand...

Another fast n easy way is to create a pivot. Assuming the col label is
Vendor, in step 3 of the wiz., click Layout, then drag n drop Vendor into
both the ROW and DATA areas. Click OK > Finish. Done! Hop over to the pivot
sheet for the desired results: the required uniques list in the 1st col, with
corresponding counts in the 2nd.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
 
Back
Top