Hello,
Right now I'm using this formula to get the most common words from this column, however it returns me blank (because it's the most common value):
=IFERROR(INDEX(RawData!$M$1:$M$100,MODE(IF(ISNA(MATCH(RawData!$M$1:$M$100,I$1:I1,0)),MATCH(RawData!$M$1:$M$100,RawData!$M$1:$M$100,0)))),"")
How do I correct this such that it doesn't count with the blank cells?
Cheers
Bookmarks