Hello,



i was wondering if anyone can help me.

I'm looking to find the most number in a column depending on the criteria.

For example:

If i have color cars and then there are numbers next to them....

Red 1
Red 1
Blue 2
Blue 3
Red 2
Red 1

I would like to have a formula that will say that in a separate cell, just place the number 1 to show that red 1 is the most common number.

any help would be appreciated

=index(a1:a6,mode(match(a1:a6,a1:a6,0)))