| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count periods in a cell
Hi,
I cannot get Countif to return the number of periods in cell A1 (formatted as text) : "1.1.1.1" Thanks for your help Cheers Carim |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count periods in a cell
=LEN(A1)-LEN(SUBSTITUTE(A1),".","")
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Carim" wrote in message oups.com... Hi, I cannot get Countif to return the number of periods in cell A1 (formatted as text) : "1.1.1.1" Thanks for your help Cheers Carim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count periods in a cell
As usual ... thanks to Tom O ... found the answer : =LEN(A1)-LEN(SUBSTITUTE(A1,".","")) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count periods in a cell
Hi Bob,
Thanks a lot ... our messages crossed ... Regards Carim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count cells, then reset count when value in another cell changes | Excel Worksheet Functions | |||
| How to count the number of months between 2 periods? | Excel Discussion (Misc queries) | |||
| How do I add periods to complete a word in a cell? | Excel Discussion (Misc queries) | |||
| 13 periods | Charts and Charting in Excel | |||
| COUNT SEPARATE PERIODS IN COLUMN | Excel Programming | |||
![Carim[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
