Thank you for taking the time to read my question.
I have a data table with many customers. Each customer has many sites. I'm wondering if it's possible to use Excel formulas to return the unique list of sites based on the Customer name entered into a cell. Next I'd like to be able to show the unique values horizontally.
Is this possible or do I need to write a quick macro?
Data Table:
Customer 1 Site 1 Other data
Customer 1 Site 1 Other data
Customer 1 Site 1 Other data
Customer 1 Site 1 Other data
Customer 1 Site 1 Other data
Customer 1 Site 2 Other data
Customer 1 Site 2 Other data
Customer 1 Site 2 Other data
Customer 1 Site 2 Other data
Customer 1 Site 3 Other data
Customer 2 Site A Other data
Customer 2 Site A Other data
Customer 2 Site B Other data
Customer 2 Site B Other data
User Input: Customer 1
Result I'd like to see
A B C
1| Site 1 | Site 2 | Site 3
I found the Unique() function but I need to pass it a range of cells and I'm not sure how to do that. I also found the Transpose() function which I thought I could put the Unique() function in.
=Transpose(Unique("The range I'm not sure how to pass",True,True))
Thanks


