Thread
: [Solved]
need help in counting the number of rows that contain 5 consecutive X
View Single Post
11-19-2018, 01:04 AM
Marcia
Windows 7 32bit
Office 2007
Expert
Join Date: May 2018
Location: Philippines
Posts: 551
Hi Xor. If a helper column (Col H) could be avoided through a straight formula in B6 to return "2", I would prefer that. In the sample sheet, there are 2 rows that are populated with at least five consecutive "x".
Marcia
View Public Profile
Find all posts by Marcia