ExcelBanter - contineous cont

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

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

- - contineous cont (https://www.excelbanter.com/excel-discussion-misc-queries/447971-contineous-cont.html)

A Biseshwar Singha

contineous cont

Please help me in continuous counting of P in below

P P A P P
P P P P P

Kevin@Radstock

Have you tried the COUNTIF function.

Quote:

Originally Posted by A Biseshwar Singha (Post 1608547)

Please help me in continuous counting of P in below

P P A P P
P P P P P

A Biseshwar Singha

Quote:

Originally Posted by Kevin@Radstock (Post 1608551)

Have you tried the COUNTIF function.

Dear Kevin,

I have tried count if but it count only present. I want to know only contentious four "P". Please suggest.

shanermuls

Quote:

Originally Posted by A Biseshwar Singha (Post 1608602)

Dear Kevin,

I have tried count if but it count only present. I want to know only contentious four "P". Please suggest.

Will it always just be 5 letters? Can there be more than one "A"?

All times are GMT +1. The time now is 05:45 AM.