00:00Here's a problem for you. If a dealership were to sell different car models that day,
00:04it should sell multiple models. But if the dealership sold only one model that day,
00:09it should display the car model is sold. Something like this. Quite a simple request if you ask me.
00:15Here's how I solved it. We start off with a filter function looking for models in column C
00:20that were sold on 2nd of August by the dealership John, which returns Ferrari for our example.
00:26But if we copy the same formula over to the 2nd row, we find that Ava sold 3 models that
00:31day.
00:32We can easily count the models sold using a count if function like this. But first,
00:37let's encapsulate the filter function with the unique function. This is gonna be a perfect fit
00:42for if condition. If the value is greater than 1, we're gonna display multiple models. Otherwise,
00:47assume that the dealership only sold one model and displayed that single model.
00:50Now apply the same formula for all rows and voila, all done.
