Capture.PNG

Hi

I am looking for a formula that will allow me to return the value of the Name that occurs the most times in a row.

The formula need to only look at certain Cells opposed to the full row as I only want it search the Name Columns and not include what is in the Status columns.

The Name columns are actually merged over 5 columns.

Any advice is gratefully appreciated.