How would I determine the frequency of a text cell, based on a specific
criteria, and then have it display the most frequent text. In other words,
let say you have the following:

Car Make Model Parts
Honda Accord Fan
Chevy Blazer Hose
Honda Civic Glass
Honda Accord Belts
Honda Accord Fan
Chevy Blazer Hose
Chevy Impala Hose
Honda Accord Fan


How would I be able to determine which part is most frequently used, based
on the spefic "Make" and "Model" criteria and then display the most needed
part.
In other words:

Car Make Model Most Used Part
Honda Accord FAN
Chevy Blazer HOSE


Any asistance would be greatly appreciated