Help with a frequency

  • Thread starter Thread starter rmort27
  • Start date Start date
R

rmort27

I need to perform a frequency on a list of text
I know that the frequency function ignores text
Is there any other way to perform the same style of analysis on a list
of text?

Thanks in Advance for your help?
Rick
 
Check the COUNTIF function or use XL's PivotTable capability.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Put this is a cell and instead of pressing the enter key press
Control+Shift+Enter - All simultaneously; this will automatically enter
{ } 's at the beg and end - You cannot do this manually -==

=SUM(1/COUNTIF(A2:A100,A2:A100))

Afterwards your cell will produce the answer you want, AND the formula will
look like this:

{=SUM(1/COUNTIF(A4:A19,A4:A19))}

HTH
 
Put what in a cell? "=SUM(1/COUNTIF(A2:A100,A2:A100))" <--
- that? I'm not sure I understand how to do this. How will
it understand which data in the column i wanted counted?
 
OK, here we go:
I gave you a sample. My sample which you can put into cell B1, or C2
(either) if it is blank and available... anyway it is a single cell formula
that will examine the content of the Range of cells A2:A100 (which contain
99 strings of data; like Joe, Henry, Tom, Woodrow...; the formula examines
each of the 99 cells and in cell B1(let's say) tells you "How many Unique
names appear in the List (A2:A100). That is what you wanted, Right?
Try that, and write back if you have problems.......
HTH
 
Actually what I need it to do is tell me the amount of duplicates in the
list.
The list is names and there are over 6000 of them
but some of them are the same
Just like when you run a histogram on a list of numbers it will give
the number and the frequency of the number
I want the name and the frequency of the name
unforunately the histogram function doesn't work on text

Thanks Again
Rick
 
I could be wrong -- or just to prove me wrong someone might <g> -- but
it is highly doubtful that anyone will download the file. It might be
in your best interest to continue this dialog through a 'text only'
format.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 
Here is a simple pivot table that perfoms a frequency count on text
found in the excel range("MyNames").

I made this by doing the following:
1. I added a label to the top of my list "MyNames"
2. I selected the range plus the label and Named it "MyNames"
in the Name box
3. I created a pivot table:
Data|Pivot Table
When asked where is the data source: Range: MyNames|NEXT
4.Options|Fields per col: 1
5. Layout: Drag "MyNames" to Row
also Drag "MyNames" to Data
6. click OK|FINISH

File Attached: http://www.exceltip.com/forum/attachment.php?postid=306919 (namecount.xls)
 
Back
Top