Why am I getting NA

P

pcor

I was surfing Chip Perason web page- real good stuff there- and came about
the following formula
=INDEX(Rng,MATCH(MAX(COUNTIF(Rng,Rng)),COUNTIF(Rng,Rng),0))

I was interested in trying it out
so in Col A I placed
12
12
34
5
6
7
8
Named range Rng(a1 to a7)=Sheet1!$A$1:$A$8

I placed the above formula in C10
The answer I got was N/A
What Am I doing wrong
Thanks
-- Norton Virus checker 2003 says this email is clean
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Most frequent item in a list (excluding zeros) 3
Why doesn't this array formula calculate properly using VBA? 0
Code For Copy Copies Twice 4
Copy full sheet of just values and formates if possible, am I on the right track? 4
Modifying Ron's Sub Copy_To_Workbooks 2
Help needed Writing formula that totals data at end of column 7
Trying to improve efficiency of array formula 8
Finding the minimum value in a list but excluding zeros - a variationon an old problem 10

Top