Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count number of instances a number occurs
Hi All,
i am trying, without success to creat a formula to do the following: i have a series of values in a column and want to show how manay time a number occurs within a range from the list. i.e. in my list i have 12,17,23,24,25,23,24,22,26,43,32,32,33,44,53 i then want to display the number of instance there is an occurance of: <10, 10-20, 21-30, 31-40, 41-50, 51 I would appreciate any assitance you might offer. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Count the number of times a value occurs within a dt range | Excel Worksheet Functions | |||
Count the number of times a name occurs in a column | Excel Worksheet Functions | |||
How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
How do I count the times a number occurs in a given criteria? | Excel Discussion (Misc queries) |