Hello to all,
In the uploaded file (just a small amount of data), column A, I have all my customers and in column B I have all products they buy. On column C I have a list of all unique products sold, regardless from customer. What I would like to have, on column D is a list of the same unique products but depending on the customer selected on cell E1.
Many thanks in advance for any kind help.
OT
Why don't you just insert a Pivot Table? Add Customers to the Repor Filter and Products to the Row Labels.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Many thanks for answering, Trevor. I was just trying to avoid pivot tables...
Try
D2Formula:
Please Login or Register to view this content.
Drag down!!
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Many thanks but it is not returning unique values...
OT
Try array entering this in D2 and fill down. It returns unique products for customer in E1.
If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Formula:Please Login or Register to view this content.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks