Need formula that will categorise ages. Column P contains the age of 4983 people. What I need to do is put these ages into categories in column Q:
0
1-4
5-9
10-14
15-19
20-24
25-29
30-34
35-39
40-44
45-49
50-54
55-59
60-64
65-69
70-74
75-79
80-84
85-89
90-94
95-99
100-104
105-108
So, if the person's age is 86 in column P2, column Q2 should read 85-89.
I would like to be able to categorise some data by reference to a list of values e.g. How do I categorise a range of retail stores by turnover :
Store A has a turnover of £8m and I have a range of turnover bands :
0 - 1M = category 1
1M - 5M = category 2
5M - 10M = category 3
> 10M = category 4
I would like to assign a category number based on a lookup against the banding table. I can do this with a formula consisting of nested if statements but that is very cumbersome and with large volumes of data it becomes very slow in recaulating all the formula.
I have searched the forums to see if there is a similar prob already answered but to no avail (apologies if this has already been answered).
I am designing a sheet for a Uni project that needs to calculate the average attendance rates for students between age groups. My data has the age in a specific age for example:
Age
18
19
19
21
etc.
I am trying a SUMIF function that adds all attendance rates based on a criteria - however I can't get the criteria to fall between two ages ranges (more specifically, I need to sum the averages where the ages is between 21 - 25), as the function seems to only allow for one expression of criteria.
My function currently Reads:
=SUMIF(A1:A25, ">=21 & <=25", B1:B25)
Where A is the column recording ages and B is the column recording attendance rates. It presently returns 0.
Is there a better function for this task, or a way around the SUMIF criteria?
I am trying to find a formula to find out peoples ages from their date of birth but on different dates.I know you can do age from DOB 'today' or on a given date, but I have date of birth in column A and the date they were seen in column B and I would like their age in column C. Is this possible?
eg
Date of birth | Date seen | Age at date seen
01/05/1989 | 01/01/2011| ?
02/02/1956 | 02/03/2012| ?
05/02/1930 | 05/05/2009| ?
I am finally at the end of this project. I need to find a code that will copy any lines that the person has turned 65 in the previous month or that will turn 65 in the current month to the Monthly tab.
Sample Macro jscalem.xlsx
I want vlookup to return results based on the *** and age of the person from tables in a separate sheet. For eg. if the person is "male" or "female" and if the person is "<=15", "16", or "17". I have been practicising with a formula that looks like this:
View 6 Replies View Related