Hello, I am trying to find the highest mode of a set of values.

Everywhere I read said I need to sort the data as it will return the first value with the highest frequency.

the problem is, I need the data in the order it is in, and I cannot find a "sort range" function for excel, I have tried to write a VB function to do it, but I am having trouble just trying to understand the syntax on a language as old as VB

I So far have in cell M3 =MODE($D3:$K3)
which works great if the data is 4, 7, 7, 7, 5, 5, 5, 3
the problem arrises when its 4, 5, 5, 5, 7, 7, 7, 3 as it is returning 5.

and like I said, I need the data to stay in that order as its apart of an array of figures that will be done on rows 4 5 6 7 8 and 9
if I start sorting them the values will then be misalligned.

Ideally I need something like M3 =MODE(SORT($D3:$K3)) but when I type in SORT in the help all I get is press the ^AvZ Button thing, which like I mentioned I cannot use..

I have also found functions on the net to help me find the "Second" highest MODE, but I dont need the 2nd highest, I need the Highest value of Highest frequency..

Sorry I have rambled on, I'm hoping You can help.