Hello,
I am searching for two things - one is plan A and one is plan B
I need to find the most common value(s) across multiple pages in a column. (All the Data would be in the same column across all pages)
OR if that cannot be done
Search for the most common value in a large table A1:Z500
I tried this and it isn't working - returns NA
=INDEX($M$3:$X$16,MATCH(MAX(COUNTIF($M$3:X$16,$M$3:$X$16)),COUNTIF($M$3:$X$16,$M$3:X$16),0))
Any help would be appreciative. I am not familiar with UDF or pivot tables but i can learn.
Thanks,
Dan
Bookmarks