Most common text

I need a formula to compare the text (test will be one of the following: FREQ, PROB, OCC, REM, IMP, INC) in every third column of row 42 (i.e starting at C42, then F42 etc) and display the most common instance of the word in the final cell (column DE42)

 

By: Niall

Leave a Reply

Your email address will not be published. Required fields are marked *