| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Names
In column A I have data that contains names. Most entries have a commar between Surname and First name. I need a formula that will count how many names (rows) have a commar in them. The numer of rows will change as names are added or removed Thanks in advance. -- mudraker ------------------------------------------------------------------------ mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473 View this thread: http://www.excelforum.com/showthread...hreadid=554445 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Names
To count the number of commas
=COUNTIF(A:A,"*,*") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mudraker" wrote in message ... In column A I have data that contains names. Most entries have a commar between Surname and First name. I need a formula that will count how many names (rows) have a commar in them. The numer of rows will change as names are added or removed Thanks in advance. -- mudraker ------------------------------------------------------------------------ mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473 View this thread: http://www.excelforum.com/showthread...hreadid=554445 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Names
Try this:
=COUNTIF(A:A,"*,*") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "mudraker" wrote in message ... In column A I have data that contains names. Most entries have a commar between Surname and First name. I need a formula that will count how many names (rows) have a commar in them. The numer of rows will change as names are added or removed Thanks in advance. -- mudraker ------------------------------------------------------------------------ mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473 View this thread: http://www.excelforum.com/showthread...hreadid=554445 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNT forumula problem | Excel Discussion (Misc queries) | |||
| Count unique values among duplicates in a subtotal range | Excel Discussion (Misc queries) | |||
| The filter didn't show all (2,254) names when I set it up | Excel Discussion (Misc queries) | |||
| Combine query to count products with similar names | Excel Worksheet Functions | |||
| how can I count distinct names in an excel list? | Excel Discussion (Misc queries) | |||
Linear Mode
