retrieve & count text
 

I have a column with text and blank cells. I need a formula that will not
only retrieve the names of the unique text values but also give me a count
how many times they appeared. Example:

Col A
[blank]
Apples
Pears
[blank]
Apples
Oranges

Apples 2
Pears 1
Oranges 1

It could be in 2 different columns...

Thanks in advance!

retrieve & count text
 

Have a look in Help at COUNTIF then come back if you need more.
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"JN" wrote in message
...
I have a column with text and blank cells. I need a formula that will not
only retrieve the names of the unique text values but also give me a count
how many times they appeared. Example:

Col A
[blank]
Apples
Pears
[blank]
Apples
Oranges

Apples 2
Pears 1
Oranges 1

It could be in 2 different columns...

Thanks in advance!

retrieve & count text
 

I can only get that statement to work if I already know the text I'm looking
for. Col A will change constantly and is user defined.

"Bernard Liengme" wrote:

Have a look in Help at COUNTIF then come back if you need more.
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"JN" wrote in message
...
I have a column with text and blank cells. I need a formula that will not
only retrieve the names of the unique text values but also give me a count
how many times they appeared. Example:

Col A
[blank]
Apples
Pears
[blank]
Apples
Oranges

Apples 2
Pears 1
Oranges 1

It could be in 2 different columns...

Thanks in advance!

retrieve & count text
 

On Fri, 24 Aug 2007 12:28:03 -0700, JN wrote:

I have a column with text and blank cells. I need a formula that will not
only retrieve the names of the unique text values but also give me a count
how many times they appeared. Example:

Col A
[blank]
Apples
Pears
[blank]
Apples
Oranges

Apples 2
Pears 1
Oranges 1

It could be in 2 different columns...

Thanks in advance!

Although not a formula, you could use a pivot table to list both the unique
entries and their count.

You could also use the advanced filter to list the unique entries, and countif
to get the count.

You could also sort your data, then use the subtotals wizard to get a count of
each item.
--ron

retrieve & count text
 

Absolutely perfect! Thank you Thank you Thank you!

"Ron Rosenfeld" wrote:

On Fri, 24 Aug 2007 12:28:03 -0700, JN wrote:

I have a column with text and blank cells. I need a formula that will not
only retrieve the names of the unique text values but also give me a count
how many times they appeared. Example:

Col A
[blank]
Apples
Pears
[blank]
Apples
Oranges

Apples 2
Pears 1
Oranges 1

It could be in 2 different columns...

Thanks in advance!

Although not a formula, you could use a pivot table to list both the unique
entries and their count.

You could also use the advanced filter to list the unique entries, and countif
to get the count.

You could also sort your data, then use the subtotals wizard to get a count of
each item.
--ron

retrieve & count text
 

On Tue, 28 Aug 2007 08:58:02 -0700, JN wrote:

Absolutely perfect! Thank you Thank you Thank you!

You're welcome. Glad to help. Which suggestion did you wind up using?
--ron