Return list of products excluding duplicates

**Chanley24** · 05-20-2013, 02:04 AM

Hi

I have a spreadsheet with contains a large number of customers and the products they have purchased over the last 3 months.

If for example they have purchased bacon on more than one occasion during the 3 month period then bacon will appear in the spreadsheet for this customer more than once.

I have created a report with has a drop down list where i can select which customer i want to view. Upon selecting the customer i want a list of products they have purchased over the 3 month period to be displayed excluding duplicates eg bacon will only appear on the list once not multiple times.

I have attached an extract from the spread sheet and my preferred result for you to review.

Any further questions please ask.

Thanks

Colin

**humdingaling** · 05-20-2013, 02:10 AM

Hi Colin

Have you tried using a pivot table?

**Chanley24** · 05-20-2013, 02:36 AM

Hi Humdingaling

I haven't.

I know how to use pivot tables i have no experience on how to create them.

If you think a pivot table is my best option im certainly happy to go away and look into creating one.

**humdingaling** · 05-20-2013, 02:40 AM

pivot tables are not hard to learn at all
they just look daunting when you first see them

see the attached file i put in "sheet 4"
i basically did that in under 10 button clicks
no formulas to mess

customer filter at top to select which customer you want

**Fotis1991** · 05-20-2013, 02:59 AM

And here is a formula suggestion.

In H7 and copy down and across this ARRAY formula.

=INDEX($B$2:$D$82, MATCH(0,COUNTIF($H$6:H6,$B$2:$B$82)+($A$2:$A$82<>$H$5),0), COLUMN(A1))

**Chanley24** · 05-20-2013, 03:07 AM

Thanks Fotis

That works fine. I will use the Array formula for the short term as it answers my immediate needs.

I have been looking into pivot tables further in the last 30 mins and i think pivot table will allow me to extract a lot more info over time from the data that i have. Info that we previously thought was above too difficult to extract.

Thanks all for your help.

**Fotis1991** · 05-20-2013, 03:11 AM

.........................

**ketats1** · 05-21-2013, 11:14 AM

01-Manual Aspiration-Advance-Template.xlsx 01-Manual Aspiration-Advance-Template.xlsx
Hello,

I would need your help on he following please.

in tab : report- I'll choose the country.
in tab : Extract ESr: data will be changed accordingly to the selection.

and data will be cleaned in column T-U- V- W.

I need kind of macro in Column X (or formula), to extract unique value from column W. Without duplicates,

This will allow me to make a reference in Tab report to put this code into a table without duplicates.

Thank you for your help.

**ketats1** · 05-21-2013, 11:15 AM

Sorry fr this,

Just i forget to mentioned that i need the macro to run each time we change the selection of the country.

Thank you

**Fotis1991** · 05-22-2013, 02:21 AM

I(We)'d like to help you but you need to start your own thread according the forum rules.

Just for starting take a look here.

http://www.get-digital-help.com/2009...om-one-column/

Return list of products excluding duplicates

LinkBack

Thread Tools

Rate This Thread

Display

Return list of products excluding duplicates

Re: Return list of products excluding duplicates

Re: Return list of products excluding duplicates

Re: Return list of products excluding duplicates

Re: Return list of products excluding duplicates

Re: Return list of products excluding duplicates

Re: Return list of products excluding duplicates

Re: Return list of products excluding duplicates

Re: Return list of products excluding duplicates

Re: Return list of products excluding duplicates

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions