unique values given condition

[guscrouchend]

i have a table 3000 rows long.

Col A = Clients
Col B = Service

I have over 30 services on a separate list. The average clients takes 2-5 services.

I would like, for a given client, to list all the services that they have taken: I would like to scan the table and list all unique services for a given client name.

How might I do this? Could i create this list as a horizontal row? (Col A = 'client' and cols B, C, D, E etc would be the different services).

All help much appreciated

gus

 

[wigi]

Could i create this list as a horizontal row? (Col A = 'client' and cols B, C, D, E etc would be the different services).

That's the standard behaviour you would get with a Pivot table. Insert one and see how easy it is.

 

[guscrouchend]

thanks mate...time to learn about pivot tables!