Array Formulas
Brilliant Thank you to both of you.
I'll push my luck now!, is there any easy way to get e.g. 01/02/08 or
01-Feb-08 to change to Feb so that in my previous example its sees
them both as the same thing and not formated to be that. I have tried
using =month(a1) but it doesnt always seem to return the correct
Month. So am having to type in the related month. This is ok except
if the core data changes it will not automatically update.
Thanks again for all your help
Mags
|