Hello! I am curious if anyone knows how to solve my issue I am experiencing in Microsoft Excel. I am trying to find the average word from a column that contains solely Dependent Drop-Down Lists. In a cell, I have the following formula:
=INDEX(F3:F8,MODE(MATCH(F3:F8,F3:F8,0)))
Unfortunately, I get the infamous #N/A as a result.
I am wondering if there is a way to tell the above formula to recognize the list from F3 to F8 as words vs information found from a Dependent Drop-Down List.
I hope this makes sense and I am glad to provide more information if needed! Thanks for you help!
What I have tried:
I have tried the above formula with no luck?