Looping with the most frequent cell in collumn

[JODomingos]

Hi Fellows!

I am trying to create a macro to perform a looping with the most frequent formula in multiple columns.

I need to insert a formula at the yellow postion to return the most frequent cell in the column E, F, G .. but only for the repeated row.... and fill it right until the last filled column. After that It would repeat in multiple ranges ( A, B, C, D....)
Thanks in advance.

 

[Fluff]

Why not use the code I supplied here Average Formula with looping in multiple Range
Just change the range & formula.