View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MarkN MarkN is offline
external usenet poster
 
Posts: 104
Default Conditional age grouping

I was helped with something similar a little while ago and I now have another
similar problem but this is another step up in difficulty I think.

I need to establish how many people are in 5 age bands (the last being age
not provided). However, these totals are conditional on whether the value in
column a = "text1" or "text2" but column b < "text3". Column e lists
birthdates.

--
Thanks in advance as always,
MarkN