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
|