Data selection

[Peggia]

Which formula I need to use to solve this problem:
I have table with three columns:
A: Product name
B: Date
C: Complains about product

In column A most of products are inputed several times for diferent days in column B.
In new sheet i want to sort only date for one of the specific product with associated complain for that date.

Thanks in advance

 

[AlanY]

try this

data sheet

Excel 2012
	A	B	C
1	Product name	Date	Complains about product
2	Product 1	03/11/2016	Complains 1
3	Product 1	11/12/2016	Complains 2
4	Product 1	28/11/2016	Complains 3
5	Product 2	21/11/2016	Complains 4
6	Product 3	12/12/2016	Complains 5
7	Product 3	04/12/2016	Complains 6
8	Product 3	02/11/2016	Complains 7
9	Product 3	13/11/2016	Complains 8
10	Product 4	03/12/2016	Complains 9
11	Product 4	12/12/2016	Complains 10
Sheet5

summary sheet

Excel 2012
	A	B	C
1	Product name	Date	Complains about product
2	Product 3	04/12/2016	Complains 6
3	Product 1	28/11/2016	Complains 3
4	Product 4	12/12/2016	Complains 10
Sheet6

Cell Formulas
Range	Formula
C2	{=INDEX(Sheet5!$C$2:$C$11,MATCH(A2&B2,Sheet5!$A$2:$A$11&Sheet5!$B$2:$B$11,0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[James006]

Hi,

The easiest solution ... is to create a Pivot table ...:wink:

Pivot Tables in Excel - EASY Excel Tutorial

HTH

 

[Peggia]

Thanks guys but i don't need to summarize number of complains. I just wont to see date and text of complain for that date for specific product in new sheet. Product name will be name of the new sheet

 

[AlanY]

Thanks guys but i don't need to summarize number of complains. I just wont to see date and text of complain for that date for specific product in new sheet. Product name will be name of the new sheet

does post#2 met your requirements?