I have a range of numbers on column "A" where some of numbers have been repeated several times. My question is:" How can I find the value more than zero with highest frequency in a range?
I tried below formulas but it does not work truly (sometimes gives me true value and sometimes gives me wrong value). On the other hand, I need the value more than zero with highest frequency.
=INDEX(B:B, 10000*MOD(MAX(COUNTIF(B2:B16,B2:B16)+(ROW(B2:B16)/10000)),1), 1)
=INDEX(B2:B20;MODE(MATCH(B2:B20;B2:B20;0)))
Do you have any solution for my problem?
Thanks in advance for your cooperation.
Please see enclosed excel file.
Bookmarks