| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Frequency questio
I have a column of data and i would like to know what number occur the most
frequently. I dont know how to accomplish this though...could anyone please help me? Thank you if you can! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Frequency questio
=INDEX(rng,MATCH(MAX(COUNTIF(rng,rng)),COUNTIF(rng ,rng),0))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "meegan" wrote in message ... I have a column of data and i would like to know what number occur the most frequently. I dont know how to accomplish this though...could anyone please help me? Thank you if you can! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Frequency questio
Hi!
Would this help? =MODE(your_column) -- Thanks and kind regards "meegan" wrote: I have a column of data and i would like to know what number occur the most frequently. I dont know how to accomplish this though...could anyone please help me? Thank you if you can! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Frequency questio
where do i insert the formula
"Bob Phillips" wrote: =INDEX(rng,MATCH(MAX(COUNTIF(rng,rng)),COUNTIF(rng ,rng),0)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "meegan" wrote in message ... I have a column of data and i would like to know what number occur the most frequently. I dont know how to accomplish this though...could anyone please help me? Thank you if you can! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Frequency questio
where would I put that formula?
"RaymundCG" wrote: Hi! Would this help? =MODE(your_column) -- Thanks and kind regards "meegan" wrote: I have a column of data and i would like to know what number occur the most frequently. I dont know how to accomplish this though...could anyone please help me? Thank you if you can! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Frequency questio
Hi again meegan,
You may enter the formula anywhere w/in the spreadsheet except the column containing the data. the your_column previously mentioned in the formula means you have to select the range containing the data Hope this helps! :) -- Thanks and kind regards "meegan" wrote: where would I put that formula? "RaymundCG" wrote: Hi! Would this help? =MODE(your_column) -- Thanks and kind regards "meegan" wrote: I have a column of data and i would like to know what number occur the most frequently. I dont know how to accomplish this though...could anyone please help me? Thank you if you can! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Frequency questio
what do i put in for the ranges...its in column C rows 1-57
"Bob Phillips" wrote: =INDEX(rng,MATCH(MAX(COUNTIF(rng,rng)),COUNTIF(rng ,rng),0)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "meegan" wrote in message ... I have a column of data and i would like to know what number occur the most frequently. I dont know how to accomplish this though...could anyone please help me? Thank you if you can! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Frequency questio
Bob's formula...
=INDEX(C1:C57,MATCH(MAX(COUNTIF(C1:C57,C1:C57)),CO UNTIF(C1:C57,C1:C57),0) ) ....confirmed with CONTROL+SHIFT+ENTER. Raymund's formula... =MODE(C1:C57) ....confirmed with just ENTER. Note that MODE will return #N/A when no number occurs more than once. Also, what if there's more than one number occurring most often? In article , meegan wrote: what do i put in for the ranges...its in column C rows 1-57 "Bob Phillips" wrote: =INDEX(rng,MATCH(MAX(COUNTIF(rng,rng)),COUNTIF(rng ,rng),0)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "meegan" wrote in message ... I have a column of data and i would like to know what number occur the most frequently. I dont know how to accomplish this though...could anyone please help me? Thank you if you can! |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Frequency questio
Hi!
For multimodal data, we can use the FREQUENCY function instead. As per example if data is in C1:C57, we can select the output range as D1:D57 then enter the ff as an array formula (using CTRL+SHIFT+ENTER): =FREQUENCY(C1:C57,C1:C57) From there we can determine the number of occurences for each value. Hope this helps! -- Thanks and kind regards "Domenic" wrote: Bob's formula... =INDEX(C1:C57,MATCH(MAX(COUNTIF(C1:C57,C1:C57)),CO UNTIF(C1:C57,C1:C57),0) ) ....confirmed with CONTROL+SHIFT+ENTER. Raymund's formula... =MODE(C1:C57) ....confirmed with just ENTER. Note that MODE will return #N/A when no number occurs more than once. Also, what if there's more than one number occurring most often? In article , meegan wrote: what do i put in for the ranges...its in column C rows 1-57 "Bob Phillips" wrote: =INDEX(rng,MATCH(MAX(COUNTIF(rng,rng)),COUNTIF(rng ,rng),0)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "meegan" wrote in message ... I have a column of data and i would like to know what number occur the most frequently. I dont know how to accomplish this though...could anyone please help me? Thank you if you can! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
| 3-D Frequency Chart in VBA | Charts and Charting in Excel | |||
| Frequency function | Excel Discussion (Misc queries) | |||
| Frequency for Histograms in Excel | Charts and Charting in Excel | |||
| Cumulative Frequency | Charts and Charting in Excel | |||
Linear Mode
