Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell frequency II
First answer seemed to work, but look at this:
I want to change from 450 420 400 420 400 into a matrix like this: value frequency 450 1 420 2 400 2 Thank you. Sergio |
#2
|
|||
|
|||
Use a Pivot Table. In the layout section (step 3), drag
the Value field to the ROW area, and drag it again to the DATA area. Make sure it says COUNT OF VALUE. These 3 sites have excellent Pivot Table tutorials: http://www.cpearson.com/excel/pivots.htm http://edferrero.m6.net/Pivot.html http://it.fuqua.duke.edu/public/2001...leIntroduction HTH Jason Atlanta, GA -----Original Message----- First answer seemed to work, but look at this: I want to change from 450 420 400 420 400 into a matrix like this: value frequency 450 1 420 2 400 2 Thank you. Sergio . |
#3
|
|||
|
|||
Sergio Magni -
Since you've started a new thread, I don't know about the "First answer." But, in general, there are at least three ways to get what you want. (1) The array-entered worksheet funtion FREQUENCY. (2) The Histogram tool of Excel's Analysis ToolPak add-in. (3) The COUNTIF worksheet function. Another method is my Better Histogram add-in, available at www.treeplan.com. - Mike "Sergio Magni" wrote in message ... First answer seemed to work, but look at this: I want to change from 450 420 400 420 400 into a matrix like this: value frequency 450 1 420 2 400 2 Thank you. Sergio |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Frequency | Excel Worksheet Functions | |||
HOW to COUNT THE FREQUENCY of specific CHARACTER WITHIN a CELL? | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |