Forum Discussion
LWE_SE
Feb 14, 2020Copper Contributor
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...
SergeiBaklan
Feb 14, 2020Diamond Contributor
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
Feb 17, 2020Copper Contributor
SergeiBaklan Success - Thank you.