![]() |
#8
|
|||
|
|||
![]()
In the formula in your first post you used:
=SUM(IF(FREQUENCY(IF(ISNUMBER(SEARCH("X",$A1:$G1)) ,COLUMN($A1:$G1)-COLUMN($A1)+1),IFERROR(SEARCH("X",$A1:$G1),COLUMN( $A1:$G1)-COLUMN($A1)+1))>=5,1)) and in the formula in the most recent file: SUM(IF(FREQUENCY(IF(ISNUMBER(SEARCH("X",$A1:$G1)), COLUMN($A1:$G1)-COLUMN($A1)+1),IF(ISERROR(SEARCH("X",$A1:$G1)),COLUMN($A1:$G1)-COLUMN($A1)+1))>=5,1)) Another possibility is the somewhat shorter formula: =--(MAX(FREQUENCY(IF(ISNUMBER(SEARCH("X",$A1:$G1)),CO LUMN($A1:$G1)),IF(NOT(ISNUMBER(SEARCH("X",$A1:$G1) )),COLUMN($A1:$G1))))>=5) |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
Jennifer Murphy | Word Tables | 1 | 08-23-2016 03:00 PM |
![]() |
RavenSuzumiya | Word Tables | 1 | 06-09-2016 03:38 PM |
![]() |
Ian A King | Word | 2 | 05-11-2015 10:13 PM |