Specific Columns within a Unique List based on Multiple Criteria

[BrettOlbrys1]

I have a table of data in columns A - Z. The important columns are:

Column A - Date
Column D - Customer
Column F - Qty
Column J - Opportunity %

The customers in column D will often repeat throughout the data.

I want a UNIQUE list of customers (column D) based on a date range (column A) and based on a range of Opportunity %'s (column J). The formula should produce a list of unique customers and exclude all other columns.

When I try this myself, it gives me all columns in the data table. I want to CHOOSE which columns to appear next to the list of unique customer names.

How do I accomplish this?

Thanks

 

[Herakles]

I have a table of data in columns A - Z. The important columns are:

Column A - Date
Column D - Customer
Column F - Qty
Column J - Opportunity %

The customers in column D will often repeat throughout the data.

I want a UNIQUE list of customers (column D) based on a date range (column A) and based on a range of Opportunity %'s (column J). The formula should produce a list of unique customers and exclude all other columns.

When I try this myself, it gives me all columns in the data table. I want to CHOOSE which columns to appear next to the list of unique customer names.

How do I accomplish this?

Thanks

Can you submit your data using XL2BB please.

Where do you want this unique list to be put?

 

[Fluff]

When I try this myself, it gives me all columns in the data table.

What formula are you using?