Pull Unique Values From a List/Table

K

Karl Burrows

How can I pull unique values from a table? I track vendors who might sell
multiple items, but I only need to show the vendor once so I can pull other
information. There are also may be blanks in the rows if the vendor is
inactive.

Thanks!
 
K

Karl Burrows

Let me add one more twist to this problem:

The unique values also need to filter out where it may be 'VendorA - West'
and 'VendorA - East' and combine them into one record. I only need it to
show VendorA and not both records East and West (same company, just
different drop ship location).

Thanks!
 
B

Bob Phillips

I suggest that you add a helper column and deduce the name from it with a
formula. IF you are unsure how to do that give us some rules and we can
help.

Then do an advanced filter on the helper column, copying unique values.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top