INDEX(MATCH(MODE) Formula returning #N/A
I'm trying to search a column of text to return the text that occurs most frequently. My formula (C1) is resulting in #N/A and I can't see the issue. I've recreated in the attached file. Please help!
Thanks so much - as always! Best.Forum.Ever.
INDEX(MATCH(MODE Function Issues.xlsx
Because your formula links to another file which is not attached it is difficult to see the problem. Have you tried to add iferror(your formula),0)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Sorry that was the wrong attachment, please see attached with no external links. Thanks in advance!!
Attachment 441503INDEX(MATCH(MODE Function Issues.xlsx
It still gives me a message about external links but here is what I was recommending in post #2 =IFERROR(INDEX(A:A,MODE(MATCH(A:A,A:A, 0))),0)
will that work for you?
EDIT: or, what do you expect to see?
Last edited by Sam Capricci; 01-19-2016 at 07:55 PM.
I couldn't get that to work with the A:A, but it led me to suspect excel didn't like the full column as the range, so I shortened it to only the data present and your formula worked like a charm!! Thank you!
Well thank you for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks