Thread: Array Formulas
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] maggot_medwaysc@yahoo.co.uk is offline
external usenet poster
 
Posts: 2
Default 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