Quote Originally Posted by Marcol View Post
@ elite-fusion (OP)
Only a wild guess.... is your version of 2010 up to date with service packs?
Have you downloaded the latest updates?

There are probably more elegant solutions to your problem, but I am interested as to why that basic formula should not work.
it wasnt working because it was done on a .XLS which is a 97-03 version excel file, but it works fine in .XLSX which is a 07-10 version excel file.