need help in counting the number of rows that contain 5 consecutive X

		Microsoft Office Forums > Microsoft Excel > Excel
need help in counting the number of rows that contain 5 consecutive X

FAQ

Thread Tools

Display Modes

11-18-2018, 11:51 PM

xor

Windows 10 need help in counting the number of rows that contain 5 consecutive X

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

If I enter your formula to H1:H4 I get the results 0,1, 0, 0. You seem to indicate that you get correct result without COUNTIF.

Is that what you say?

Is it important for you to avoid a helper column?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to copy different text from word into excel on consecutive rows	mihnea96	Word VBA	4	05-08-2017 12:09 PM
Counting Consecutive Periods In Rows Using Numbers	Yaaseen23	Excel	18	03-24-2017 11:15 AM
Counting rows with a macro?	Jennifer Murphy	Word Tables	1	08-23-2016 03:00 PM
Counting table rows in a page	RavenSuzumiya	Word Tables	1	06-09-2016 03:38 PM
Problem with consecutive Figure number placements	Ian A King	Word	2	05-11-2015 10:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:18 AM.