| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count first and last characters
Dear Expert,
I have got a file which have a system generated field below. (15 rows) First character must be either "T", "F", "U". Last character must be either "D", "S", "U". How to write a function that can calculate how much "T" or "F" for the first character under the series. How to write a function that can calculate how much "D" or "S" for the last character under the series. TLD TLD FLD TLD TND UU TNS TND TNS TMD TMD TLS TMS TLD TMD |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count first and last characters
Hi Elton
Try the below =SUM(COUNTIF(A:A,{"T","F"}&"*")) =SUM(COUNTIF(A:A,"*" & {"D","S"})) -- Jacob (MVP - Excel) "Elton Law" wrote: Dear Expert, I have got a file which have a system generated field below. (15 rows) First character must be either "T", "F", "U". Last character must be either "D", "S", "U". How to write a function that can calculate how much "T" or "F" for the first character under the series. How to write a function that can calculate how much "D" or "S" for the last character under the series. TLD TLD FLD TLD TND UU TNS TND TNS TMD TMD TLS TMS TLD TMD |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count first and last characters
Thanks .... nothing can challenge you ....
"Jacob Skaria" wrote: Hi Elton Try the below =SUM(COUNTIF(A:A,{"T","F"}&"*")) =SUM(COUNTIF(A:A,"*" & {"D","S"})) -- Jacob (MVP - Excel) "Elton Law" wrote: Dear Expert, I have got a file which have a system generated field below. (15 rows) First character must be either "T", "F", "U". Last character must be either "D", "S", "U". How to write a function that can calculate how much "T" or "F" for the first character under the series. How to write a function that can calculate how much "D" or "S" for the last character under the series. TLD TLD FLD TLD TND UU TNS TND TNS TMD TMD TLS TMS TLD TMD |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count first and last characters
Hi,
you may try this For counting T or F =SUMPRODUCT(1*(LEFT(D3:D17,1)={"T","F"})) For counting S or D =SUMPRODUCT(1*(RIGHT(D3:D17,1)={"D","S"})) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Elton Law" wrote in message ... Dear Expert, I have got a file which have a system generated field below. (15 rows) First character must be either "T", "F", "U". Last character must be either "D", "S", "U". How to write a function that can calculate how much "T" or "F" for the first character under the series. How to write a function that can calculate how much "D" or "S" for the last character under the series. TLD TLD FLD TLD TND UU TNS TND TNS TMD TMD TLS TMS TLD TMD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count the Characters in a cell | Excel Discussion (Misc queries) | |||
| Count Characters in A Cell | Excel Discussion (Misc queries) | |||
| count characters | Excel Discussion (Misc queries) | |||
| count special characters | Excel Worksheet Functions | |||
| Count Characters | Excel Worksheet Functions | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
