Excel 2007 : make "text" like "mode" fuction

hello again excel experts, i need a way to convert text into a mode function, i looked around everywhere to find a formula to make this before i made this post, bu could not find anything on this manor on this formula. i got a file for 2007 so take a look,

if anyone can help this will be most appreciated, if not i'll do my best to find out how on my own XD.