| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to retrieve certain text from string? | Excel Discussion (Misc queries) | |||
| How to retrieve certain text from string? | Excel Worksheet Functions | |||
| How do I retrieve the text string from the right of a cell | Excel Worksheet Functions | |||
| Text retrieve in a list-like WS | New Users to Excel | |||
| retrieve text from merged cells | Excel Worksheet Functions | |||
Hybrid Mode
