#NAME? error

matthewlouis

Active Member
Joined
Mar 28, 2014
Messages
263
Office Version
365, 2019
Platform
Windows
I am getting the #NAME? error on this formula:

{=INDEX(O6:O130,MODE(IF(O6:O130<>"",MATCH(O6:O130,O6:O130,0))))}

I am using the SAME formula in another data set on daily market prices (the above is for weekly) . . . and I am NOT getting an error on that sheet (??)

That error says I have something wrong in the name of the formula. How can that be when it's the same formula in the other sheet and it does not error?

Thanks in advance!
 
Last edited:

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,456
maybe use: =INDEX(O6:O130,MODE(IF(O6:O130<>"",MATCH(O6:O130,O6:O130,0)))) then ctrl+shift+enter
 

Watch MrExcel Video

Forum statistics

Threads
1,100,056
Messages
5,472,205
Members
406,809
Latest member
haf19

This Week's Hot Topics

Top