Possible to span several columns + get which responses are highest numerical values?

[Jennifre]

Hi,

I'm hoping to have Excel return to me which three columns garnered the top 3 responses in terms of their numbers, of certain rows I specify.

Is this possible?

Thanks so much, I really appreciate your help!

 

[Jennifre]

Okay, well I am hoping to be able to use some variation, perhaps, of this formula, but replacing the red part (below) to mean instead, "name which responses in this column are seen the most frequently". ... Is this possible?

(Or is a different formula the answer?)

Thank you so much!!

=SUMPRODUCT(
--($DG$2:$DG$1364=$HF8),
--[COLOR=Red]ISNUMBER(MATCH(AU$2:AU$1364,{1},0))[/COLOR])/
SUMPRODUCT(
--($DG$2:$DG$1364=$HF8),
--($CH$2:$CH$1364<=4))