Hey guys
I have a column with birth dates and i want to get the correct statistics for the age reviews
The table I want to create
How many
Between 16 -23 1
Between 23 - 35 21
Between 35 - 45 2
Between 45 - 57 4
Between 57 - 65 5
Between more than 65 6
I want to eliminate the red column from the worksheet where the years are calculated
Last edited by alexgoaga; 01-08-2019 at 09:10 AM.
Self deleted
Last edited by azumi; 01-08-2019 at 09:43 AM.
=SUMPRODUCT(--(DATEDIF($A$2:$A$33,TODAY(),"y")>G10))-SUM($J$11:J11)
Why do you use UDF?
The UDF was and is used on the bigger project to get the years and months and daysOriginally Posted by tim201110
This code should be working using the sum product, looks brilliant . Thank you for your time
B2 this gives year with decimal, Eg; 35 Years 6 months is 35.5 year this will fall to 35-45
=YEARFRAC(A2,TODAY(),3)
C2 this gives only full year, Eg; 35 Years 6 months is 35 year this will fall to 23-35
=DATEDIF(A2,TODAY(),"y")
Count use Frequency with a high limit.
=INDEX(FREQUENCY(B$2:B$33,$G$5:$G$9),ROWS(J$5:J5))
New table created. Pl See file.
In G4 then copy down.
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks