Need help with sorting data...noob here!

[dazzys]

Hi All,

I have a sheet filled with data comprising all the products we have sold to our customers over the last few years. The sheet includes customer details, makes and models of kit, dates of sale, etc. I can filter data to show me for example what customers bought PRODUCT A from us without an issue but where I'm struggling is how to display a list of customers who bought PRODUCT A and PRODUCT B and then I'd like to know how to display a list of customers who bought PRODUCT A but not PRODUCT B.

When the above lists are produced I want them to include all the columns in the original sheet as this has important details like model numbers, date of sale, etc. and not just the name of the customer.

Can someone guide me through the principle of how to do this please?

Many thanks in advance.
Daz

[Curious Dude]

How are you filtering? Are products A and B listed in the same or different columns?

[FDibbins]

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[dazzys]

I've attached a small sample set of data including the field names on the top row. Hope that helps!

[Curious Dude]

I downloaded the workbook, but there are no listings for a product A or B. Do you mean Ruckus or Vigor? Are those the A and B?

[JeteMc]

This isn't the most elegant of proposed solutions, but perhaps it will help.
A helper table, which may be moved and/or hidden for aesthetic purposes, is produced using the following formulas
SNAME: =IFERROR(IF(MATCH(0,INDEX(COUNTIF(V$1:V1,I$2:I$25),,),)>COUNTA(I$2:I$25),"",INDEX(I$2:I$25,MATCH(0,INDEX(COUNTIF(V$1:V1,I$2:I$25),,),))),"")
Ruckus and Vigor: =IF($V2="","",COUNTIFS($I$2:$I$25,$V2,$D$2:$D$25,W$1))
Ruckus Only: =IF($V2="","",AND(W2>0,X2=0))
Vigor Only: =IF($V2="","",AND(W2=0,X2>0))
Both: =IF(V2="","",AND(W2>0,X2>0))
The original table is appended with three helper columns, which may be moved to other columns on the same sheet for aesthetic purposes also.
The Ruckus, Vigor and Both columns are populated using: =INDEX(Y$1:Y$25,MATCH($I2,$V$1:$V$25,0))
Use the filter drop downs in columns of the attached file to filter data.
Let us know if you have any questions.

[BigStevie1973]

I have a similar issue. I am producing a database in MS Access - which I will subsequently export into Excel - listing works to be carried out to many different properties. What I am hoping to do is highlight all of the addresses that amongst their many work items have had two specific items carried out, e.g. some properties may get new windows, some may get new doors but I would like to filter out all of the properties who get both new doors AND new windows but excluding those who only get one or the other. I saw the example that you used above but unfortunately that would not be practical for me as I would be looking to filter on many different criteria and also sometimes three, four or more criteria and it would be very time consuming to keep setting it up for all the different criteria.

Any help would be greatly appreciated, Thanks.

[AliGW]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread