| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count number of text in a column
Look at this then and tell me how I could get the report desired without
explictly naming each cell reference or actual name? My column 5800 cells with multiple and single entries. Unique Names Names used Daniel Daniel, Celia Celia Daniel Sherlock Batman,Sherlock Batman Daniel Celia Report then would be: Daniel 3 Celia 2 Batman 1 Sherlock 1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count number of text in a column
Check your other thread.
Please don't start a new thread. Daniel_ITSM wrote: Look at this then and tell me how I could get the report desired without explictly naming each cell reference or actual name? My column 5800 cells with multiple and single entries. Unique Names Names used Daniel Daniel, Celia Celia Daniel Sherlock Batman,Sherlock Batman Daniel Celia Report then would be: Daniel 3 Celia 2 Batman 1 Sherlock 1 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count number of text in a column
Try:
Assuming data in colums A & B then in column C row 2 (first row is header) put =SUM(IF(ISNUMBER(FIND(A2,$B$2:$B$6,1)),1,0)) Enter with Ctrl+Shift+Enter Copy down "Daniel_ITSM" wrote: Look at this then and tell me how I could get the report desired without explictly naming each cell reference or actual name? My column 5800 cells with multiple and single entries. Unique Names Names used Daniel Daniel, Celia Celia Daniel Sherlock Batman,Sherlock Batman Daniel Celia Report then would be: Daniel 3 Celia 2 Batman 1 Sherlock 1 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count number of text in a column
Toppers,
WOW! Well close! What do I do if the length of the column I am trying to count is different than the one with the unique list? I start to get a strange count then as below: names used count daniel daniel, celia 2 celia celia 3 batman batman 1 sherlock daniel, celia 0 sherlock 4 "Toppers" wrote: Try: Assuming data in colums A & B then in column C row 2 (first row is header) put =SUM(IF(ISNUMBER(FIND(A2,$B$2:$B$6,1)),1,0)) Enter with Ctrl+Shift+Enter Copy down "Daniel_ITSM" wrote: Look at this then and tell me how I could get the report desired without explictly naming each cell reference or actual name? My column 5800 cells with multiple and single entries. Unique Names Names used Daniel Daniel, Celia Celia Daniel Sherlock Batman,Sherlock Batman Daniel Celia Report then would be: Daniel 3 Celia 2 Batman 1 Sherlock 1 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count number of text in a column
try - entered with CSE:
=IF(A2<"",SUM(,IF(ISNUMBER(FIND(A2,$B$2:$B$8,1)), 1,0),0),"") "Daniel_ITSM" wrote: Toppers, WOW! Well close! What do I do if the length of the column I am trying to count is different than the one with the unique list? I start to get a strange count then as below: names used count daniel daniel, celia 2 celia celia 3 batman batman 1 sherlock daniel, celia 0 sherlock 4 "Toppers" wrote: Try: Assuming data in colums A & B then in column C row 2 (first row is header) put =SUM(IF(ISNUMBER(FIND(A2,$B$2:$B$6,1)),1,0)) Enter with Ctrl+Shift+Enter Copy down "Daniel_ITSM" wrote: Look at this then and tell me how I could get the report desired without explictly naming each cell reference or actual name? My column 5800 cells with multiple and single entries. Unique Names Names used Daniel Daniel, Celia Celia Daniel Sherlock Batman,Sherlock Batman Daniel Celia Report then would be: Daniel 3 Celia 2 Batman 1 Sherlock 1 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count number of text in a column
|
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count number of text in a column
If I could hire you for a day I would
"Toppers" wrote: try - entered with CSE: =IF(A2<"",SUM(,IF(ISNUMBER(FIND(A2,$B$2:$B$8,1)), 1,0),0),"") "Daniel_ITSM" wrote: Toppers, WOW! Well close! What do I do if the length of the column I am trying to count is different than the one with the unique list? I start to get a strange count then as below: names used count daniel daniel, celia 2 celia celia 3 batman batman 1 sherlock daniel, celia 0 sherlock 4 "Toppers" wrote: Try: Assuming data in colums A & B then in column C row 2 (first row is header) put =SUM(IF(ISNUMBER(FIND(A2,$B$2:$B$6,1)),1,0)) Enter with Ctrl+Shift+Enter Copy down "Daniel_ITSM" wrote: Look at this then and tell me how I could get the report desired without explictly naming each cell reference or actual name? My column 5800 cells with multiple and single entries. Unique Names Names used Daniel Daniel, Celia Celia Daniel Sherlock Batman,Sherlock Batman Daniel Celia Report then would be: Daniel 3 Celia 2 Batman 1 Sherlock 1 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count number of text in a column
FYI, I am UK-based (near Portsmouth)!
Thanks for the feedback. "Daniel_ITSM" wrote: If I could hire you for a day I would "Toppers" wrote: try - entered with CSE: =IF(A2<"",SUM(,IF(ISNUMBER(FIND(A2,$B$2:$B$8,1)), 1,0),0),"") "Daniel_ITSM" wrote: Toppers, WOW! Well close! What do I do if the length of the column I am trying to count is different than the one with the unique list? I start to get a strange count then as below: names used count daniel daniel, celia 2 celia celia 3 batman batman 1 sherlock daniel, celia 0 sherlock 4 "Toppers" wrote: Try: Assuming data in colums A & B then in column C row 2 (first row is header) put =SUM(IF(ISNUMBER(FIND(A2,$B$2:$B$6,1)),1,0)) Enter with Ctrl+Shift+Enter Copy down "Daniel_ITSM" wrote: Look at this then and tell me how I could get the report desired without explictly naming each cell reference or actual name? My column 5800 cells with multiple and single entries. Unique Names Names used Daniel Daniel, Celia Celia Daniel Sherlock Batman,Sherlock Batman Daniel Celia Report then would be: Daniel 3 Celia 2 Batman 1 Sherlock 1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count number of specified text within a text/cell | Excel Discussion (Misc queries) | |||
| Count Number of Occurrences in a Column | Excel Worksheet Functions | |||
| How do I count the frequency of a given number in a column? | New Users to Excel | |||
| how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
![Daniel_ITSM[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
