I have a range of say B1:Z2.
In row B1:Z1 I have dates in the format dd-mmm-yy.
In row B2:Z2 I indicate presence of a person by "P". This is at infrequent appearance i.e. p,p,p,blank,blank,blank,p,p,p,p,p,blank,blank,p,p,blank,p,p,p, etc.
I am trying to find or workout a formula that would find the most repetitive Ps in row B2:Z2 and give me the sum thereof. I.e, from the above example it should be 5.
It does not have to count specifically P. Something that counts the most non-blank sequence of cells in the range should also do.
Would somebody who understands excel better than I please be so kind to assist or give me guidance.
Thank you kindly.