Yeah, sorry. Should have mentioned - already checked out Deb's excellent
site.
However, I don't see anything there that gives me what I want.
For each unique "Customer" in Column A, I'd like to return the 1-8 unique
"Locations" from Column B that are uniquely tied to that customer. Note
that each customer and location occurs many times in their respective
columns.
I guess what I want is a function that gives the result as manually using
AutoFilter. Perhaps some array function using some combination of Index,
Match, If?
Thanks
> http://www.contextures.com/xlFunctions02.html
> Check out VLOOKUP here
kletcho@gmail.com - 11 Mar 2006 22:13 GMT
Just put an autofilter on your data and filter on that customer name.
Your other option is to create a pivot table and use the filter on the
pivot table to choose your customer.