how do i count the most blanks in cells g3:g1000 ?
With this example the answer should be 12
I just want to count the most blanks between the 1's ( the 1's are only for example these could be up to anything.
1
Blank
Blank
1
1
1
Blank
Blank
Blank
Blank
Blank
Blank
1
1
1
1
1
1
1
Blank
Blank
Blank
Blank
Blank
Blank
Blank
Blank
Blank
Blank
Blank
Blank
1
1
1
1
1
1
1
1
Bookmarks