PPRuNe Forums - View Single Post - Excel dat help
Thread: Excel dat help
View Single Post
Old 10th September 2006 | 09:56
  #4 (permalink)  
jay_hl
 
Joined: Mar 2005
Posts: 124
Likes: 0
From: EGCC
XL Formula

If anyone wants to know I have devolped the following formula which seems to do the job.

=CHOOSE(ROW(),"Jan","Feb","Mar","Apr","May","Jun", "Jul","Aug","Sep","Oct","Nov","Dec")&" "&SUMPRODUCT(--(MONTH(($A$1:$A$30))=ROW()))

This first bit is for displaying the month in short in the first 12 rows only.

Rgds
jay_hl is offline  
Reply