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

Oops. That was supposed to be: =ROUNDDOWN(A2*2,-1)/2 & " - " & (ROUNDDOWN(A2*2,-1)/2)+4 Dave. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/excelda

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

Hi Sarah, A way of using worksheet formulas without a lookup table: If your data is in A2, paste this formula into an adjacent cell: =ROUNDDOWN(H16*2,-1)/2 & " - " & (ROUNDDOWN(H16*2,-1)/2)+4 It's a bit cumbersome, but gives the answer and format you need. Regards - Dave. -- -