Hi,

I'm wondering if someone can help me with an excel function I'm trying to work out for the below scenario:

Column A Column D
QLD Book shelf
QLD Book shelf
NSW Chair
QLD Pen
QLD Table

If I want to know the most common used word in Column D that is associated with 'QLD' in column A, how might I find this out? I know from looking at this basic list the most common used word in Column D for QLD is 'Book shelf' but in real life I'm working with an excel sheet that contains hundreds of lines with different data for QLD.

Thanks
Tamara