Question

To find the highest value of the cell references from D3 to K3​

Answer 1

Answer:

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..

please mark me as a brainliest

Answer 2

Answer:

find the highest value of the cells reference from D3 to K3