Fomula Advice needed for a fuel spreadsheet,

Hi,

I'm a new user to this forum and wonder if anyone can help me on this,

I am trying to create a spreadsheet from my fuel data and want to show in a cell something like if Column C (registrations) = AB12 ABC or the cell where the registration is, whats the most frequent/common station they refuelled at from the range provided (Column G). I thought mode might do it by that just seems to do numbers, and there does not seemd to be a modeif for text.

I have attached a pdf copy of the spreadsheet as an example of the spreadsheet and the ???? is where I want the formula to go. The data is fictious for example purposes.

Any help would be greatly appreciated and may stop me going insane.

Thanks

Try this formula

=INDEX(G$2:G$100,MODE(IF(J2=C$2:C$100,MATCH(G$2:G$100,G$2:G$100,0))))

confirmed with CTRL+SHIFT+ENTER