Forum Discussion

Copper Contributor

Feb 14, 2020

Formula to report most commonly entered location query

Hi, I am relatively new to larger formulas in excel and I would greatly appreciate any advice in resolving a formula issue I have. I have a spreadsheet spanning line 11 to line 400, which will refle...

excel

SergeiBaklan

Diamond Contributor

Feb 14, 2020

LWE_SE

That's like

=INDEX(AK11:AK530,MODE(IF(AK11:AK530<>"",MATCH(AK11:AK530,AK11:AK530,0))))

(array formula). Please check here Most frequently occurring text

LWE_SE
Copper Contributor
Feb 17, 2020
SergeiBaklan Success - Thank you.
LWE_SE
Copper Contributor
Feb 15, 2020
Thank you Sergei. I have entered the formula with the if statement exactly as dispalyed. There is a #NAME? Error with the open parenthesis before the if and its closing parenthesis highlighted in red. Any idea? I appreciate your support.