Multiple values with multiple criteria

[Feremartinez]

Hi,
I have the same issue.

I have the next dataset

A B C
1 PX Door 22.03.18
2 PX Door 22.03.18
3 PX Door 23.03.18
4 PX Window 24.03.14
5 PX Window 24.03.18
6 PX Window 26.03.18
7 YX Door 27.03.18

I need to get all the dates for PX in one column but without repetition.
The result should be 22.03.18, 23.03.18, 24.03.18, 26.04.18

I have tried with Vlookup, Index+Match but I cannot solve it.

Can anybody help me, please?

Thank you in advance.

[Olly]

Why not simply use a pivot table?

[Feremartinez]

Hi Olly,

thanks for answering. I donīt know how to use the pivot table. Besides, this is a easy example about what I want to do. The file where I am working on is quite big and has a lot of data. I would like to do it with a formula if possible. Can you help me with this?

thanks again.

[Olly]

If your data is "quite big", then all the more reason to use a pivot table. Give your source data headings (in this case, I used "Code", "Type" and "Date", then simply select your source data, click Insert > Pivot Table, check your source data range, and click "OK" to insert a pivot table on a new worksheet. In the Pivot Table Field list, put "Code" in the "Filters" section, and "Date" in the "Rows" section. Now click the "Code" dropdown filter and choose "PX".


If you're using Excel 2010 or later, then you could use Power Query, instead - format your source data as a table, then use something like this:

Please Login or Register  to view this content.

Attached file shows an example of both approaches.