Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with match function, i need to tally
Ok, I have thousands of rows of data. One of the columns is titled "age" and
each row has a different age. Ranging from 15-100. I need to tally these rows into age group, 0-18, 19-30, 30-50 etc etc. Is there a code i can run that will tally these for me? Thanks, -Adam |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with match function, i need to tally
Let's say the data is in column A and the groups a
15 - 30 31 - 77 78 - 100 In B1 thru B3 enter: =COUNTIF(A:A,"<31") =COUNTIF(A:A,"<78")-B1 =COUNT(A:A)-B1-B2 adapt these formula to match your specific groupings. -- Gary''s Student - gsnu200784 "Adam" wrote: Ok, I have thousands of rows of data. One of the columns is titled "age" and each row has a different age. Ranging from 15-100. I need to tally these rows into age group, 0-18, 19-30, 30-50 etc etc. Is there a code i can run that will tally these for me? Thanks, -Adam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
create tally sheet for positions- insert names and tally # | Excel Discussion (Misc queries) | |||
Tally function in excel | Excel Worksheet Functions |