I've been trying for a while to find this formula, maybe it's not possible with Excel 2000. I've tried here before but still can't find the solution having searched again now. I need this formula twice over to get statistical data for my clients. The formula should work for both sections with a minor alteration for each.
I need to find the percentage of people that are in each age range, i.e. 21-30, 31-40, 41-50 years old and so on from looking at the whole column. In the column, D5:D30 in another spreadsheet, the individuals exact age is given in the cell.
Is it possible and does anyone know the answer? Thank you for your help.
Bookmarks