top n list by criteria (including between dates)

[oysteinjha]

Hi!
I am trying to figure out how to make a top n list of the most common text based og 2 criterias (date between and text)

Assuming i have a list as shown below, in columnD i want to be able to list the top n colors from columnA based on the criteria that it is an Bmw (columnB) and sold date within 2017 (ColumnC)

[TABLE="width: 500"]
<tbody>[TR]
[TD]ColA[/TD]
[TD]ColB[/TD]
[TD]ColC[/TD]
[TD]ColD (desired result)[/TD]
[/TR]
[TR]
[TD]Color[/TD]
[TD]Car[/TD]
[TD]Sold date[/TD]
[TD]Top3 Bmw colors sold 2017[/TD]
[/TR]
[TR]
[TD]red[/TD]
[TD]Audi[/TD]
[TD]01.08.2017[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]blue[/TD]
[TD]Bmw[/TD]
[TD]01.02.2017[/TD]
[TD]blue[/TD]
[/TR]
[TR]
[TD]red[/TD]
[TD]Bmw[/TD]
[TD]01.01.2016[/TD]
[TD]yellow[/TD]
[/TR]
[TR]
[TD]blue[/TD]
[TD]Audi[/TD]
[TD]01.08.2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]red[/TD]
[TD]Bmw[/TD]
[TD]02.06.2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]blue[/TD]
[TD]Audi[/TD]
[TD]01.08.2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]red[/TD]
[TD]Bmw[/TD]
[TD]01.08.2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]blue[/TD]
[TD]Bmw[/TD]
[TD]01.08.2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]red[/TD]
[TD]Audi[/TD]
[TD]01.08.2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]yellow[/TD]
[TD]Audi[/TD]
[TD]01.01.2016[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]yellow[/TD]
[TD]Bmw[/TD]
[TD]01.08.2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]red[/TD]
[TD]Bmw[/TD]
[TD]01.08.2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]yellow[/TD]
[TD]Bmw[/TD]
[TD]01.01.2016[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Hope someone can help !

Regards,
Øystein Andresen

 

[oysteinjha]

Does anyone have a suggestion for a solution, please?

Regards,
Oystein