ExcelBanter - Count Text Syntax

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count Text Syntax (https://www.excelbanter.com/excel-discussion-misc-queries/78850-count-text-syntax.html)

nastech

Count Text Syntax

Looking for way to count repetitions in column that have letter.. "x" thanks
Have the following, but not sure how to / if need use istext..

=COUNT(LEFT(R100:R3000,1)="x")

All times are GMT +1. The time now is 02:18 PM.