oysteinjha
New Member
- Joined
- Aug 11, 2017
- Messages
- 2
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)
<tbody>
</tbody>
Hope someone can help !
Regards,
Øystein Andresen
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)
| ColA | ColB | ColC | ColD (desired result) |
| Color | Car | Sold date | Top3 Bmw colors sold 2017 |
| red | Audi | 01.08.2017 | red |
| blue | Bmw | 01.02.2017 | blue |
| red | Bmw | 01.01.2016 | yellow |
| blue | Audi | 01.08.2017 | |
| red | Bmw | 02.06.2017 | |
| blue | Audi | 01.08.2017 | |
| red | Bmw | 01.08.2017 | |
| blue | Bmw | 01.08.2017 | |
| red | Audi | 01.08.2017 | |
| yellow | Audi | 01.01.2016 | |
| yellow | Bmw | 01.08.2017 | |
| red | Bmw | 01.08.2017 | |
| yellow | Bmw | 01.01.2016 |
<tbody>
</tbody>
Hope someone can help !
Regards,
Øystein Andresen
