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-20-2018, 04:04 AM

Marcia

Windows 7 32bit need help in counting the number of rows that contain 5 consecutive X

Office 2007

Expert

Join Date: May 2018

Location: Philippines

Posts: 554

Thanks Xor, I adopted the shorter formula. Until now I could not make may brain cells to understand the two minuses before the formula. I came across the same functions when counting values in a range except blanks containing formulae. Also, I erroneously thought IFERROR and IF(ERROR) work the same.

« 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 06:52 AM.