Thread: Birthday List
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hugh Murfitt Hugh Murfitt is offline
external usenet poster
 
Posts: 10
Default Birthday List

I have a table of kids details like this:
Columns A to K contain
Child_Surname, Child_Name_1, DOB_Child_1, Child_Name_2, DOB_Child_2,
Child_Name_3, DOB_Child_3, Child_Name_4, DOB_Child_4, Child_Name_5,
DOB_Child_5

I want to produce a table with four columns: Month (in moth order), day (in
date order), Child Name and Age (in age order).

Can anyone help? I've struggled with this for a long time but never get
quite what I want!!