Frequency Function

S

Strimkind

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
 
M

mr tom

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.
 
S

Strimkind

Thank you, that worked well...will the table update automatically or do I
have to do it manually?
 
P

Peo Sjoblom

You can set it to refresh on open under table options, otherwise you need to
either use VBA or right click and select refresh.

--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top