#NAME? error

[matthewlouis]

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!

 

[sandy666]

maybe use: =INDEX(O6:O130,MODE(IF(O6:O130<>"",MATCH(O6:O130,O6:O130,0)))) then ctrl+shift+enter

 

[matthewlouis]

Ah, that did it, thanks sandy666!

 

[sandy666]

You are welcome

Have a nice day