View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mr tom mr tom is offline
external usenet poster
 
Posts: 119
Default Frequency Function

Yep.

Use a pivot table.

Select the cells you want to review. Click Data, Pivot Table Report.

Run through the wizard, putting your range of cells as both the row element
and the data element. If it puts SUM in the data element, change it to
COUNT. Click finish.

"Strimkind" wrote:

I was wondering if anyone knew of a way to get excel to list the frequency of
an alpha numeric entry and list the frequency of that particular value beside
it. For example,

33344asdf 1
43446ttgg 2

etc

Is there any way to do this?

thanks