|
|
#7
11-19-2018, 04:19 PM
|
||||
|
||||
[QUOTE]As I wrote in #2, for me it returns 0, 1, 0, 0 when entered in H1 and copied down to H4, but as you wrote yourself there are two rows that fulfil the criteria (contain 5 consecutive X.)[QUOTE]
Oh.. Maybe I accidentally deleted another X in row 3 because the formula should return 0,1,1,0. I'm re attaching the file. 
|
|
|
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 |
Windows 7 32bit 
Office 2007
Threaded Mode