Frequency of a word string in an excel database
 

Hello. I'm working on designing an excel database for our company that will
allow us to do our end-of-year APR without the headache. Part of this is
reporting on demographic information based on our funding source's format.
I'm trying to figure out how to to return a frequency string for text, so
that it will show me how many people fit into each category. For example, I
have a column that looks like this:

iii. 31-50 years Male
iii(a). 31-50 years Female
iii. 31-50 years Male
iv. 51 years or older Male
iv(a). 51 years old or older Female
iv. 51 years or older Male
ii(a). 18-30 years Female
ii. 18-30 years Male
iii. 31-50 years Male
iii. 31-50 years Male
iii. 31-50 years Male

I would need something that would tell me the frequency of each category in
the column. Can anyone help?

Frequency of a word string in an excel database
 

The 'COUNTIF' function could work for you.
--
T Tipsy


"Danny_McCaslin" wrote:

Hello. I'm working on designing an excel database for our company that will
allow us to do our end-of-year APR without the headache. Part of this is
reporting on demographic information based on our funding source's format.
I'm trying to figure out how to to return a frequency string for text, so
that it will show me how many people fit into each category. For example, I
have a column that looks like this:

iii. 31-50 years Male
iii(a). 31-50 years Female
iii. 31-50 years Male
iv. 51 years or older Male
iv(a). 51 years old or older Female
iv. 51 years or older Male
ii(a). 18-30 years Female
ii. 18-30 years Male
iii. 31-50 years Male
iii. 31-50 years Male
iii. 31-50 years Male

I would need something that would tell me the frequency of each category in
the column. Can anyone help?

Frequency of a word string in an excel database
 

Sir, you are a genius!

"Terry Tipsy" wrote:

The 'COUNTIF' function could work for you.
--
T Tipsy


"Danny_McCaslin" wrote:

Hello. I'm working on designing an excel database for our company that will
allow us to do our end-of-year APR without the headache. Part of this is
reporting on demographic information based on our funding source's format.
I'm trying to figure out how to to return a frequency string for text, so
that it will show me how many people fit into each category. For example, I
have a column that looks like this:

iii. 31-50 years Male
iii(a). 31-50 years Female
iii. 31-50 years Male
iv. 51 years or older Male
iv(a). 51 years old or older Female
iv. 51 years or older Male
ii(a). 18-30 years Female
ii. 18-30 years Male
iii. 31-50 years Male
iii. 31-50 years Male
iii. 31-50 years Male

I would need something that would tell me the frequency of each category in
the column. Can anyone help?