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

One thought on “Most common text

  1. kyrie 5

    I抎 need to verify with you here. Which is not something I often do! I take pleasure in reading a put up that may make folks think. Also, thanks for permitting me to remark!

Leave a Reply

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