Re: $$Excel-Macros$$ Macro to put singles years of age into five year age bands

2011-06-08 Thread ashish koul
check the attachment see if it helps On Wed, Jun 8, 2011 at 8:37 PM, Sarah Seager wrote: > Hi, > > I regularly have to look at raw data that shows me the age of people. > However for most of my analysis I have to convert these ages into 5 > year age bands (0-4y, 5-9y,.75-59y, 80-84y and 85+)

$$Excel-Macros$$ Macro to put singles years of age into five year age bands

2011-06-08 Thread Sarah Seager
Hi, I regularly have to look at raw data that shows me the age of people. However for most of my analysis I have to convert these ages into 5 year age bands (0-4y, 5-9y,.75-59y, 80-84y and 85+) The column that my ages is in is never the same, so I'd like my macro to run on whatever cells I se