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