retrieve & count text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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 said:
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 said:
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!
Click to expand...
Click to expand...
 
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!
Click to expand...

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
 
Absolutely perfect! Thank you Thank you Thank you!

Ron Rosenfeld said:
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!
Click to expand...

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
Click to expand...
 
Back
Top