Hello,
Please can you show me how to return the most frequently occurring text in row?
1) the row may contain blanks
2) if there is only 1 text entry, I would like that text entry to be considered the most frequent
3) if there is a draw, I would like the first text entry (from left to right) to be considered the most frequent
Thanks
If the range is say, A1:N1, then try:
=INDEX(A1:N1,MODE(IF(A1:N1<>"",MATCH(A1:N1,A1:N1,0))))
confirmed with CTRL+SHIFT+ENTER not just ENTER
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
To satisfy that condition a small tweak to NBVC's suggestionOriginally Posted by penfold
=INDEX(A1:N1,MODE(IF(A1:N1<>"",MATCH(A1:N1,A1:N1,0)*{1;1})))
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks