| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count # of cells b/w cells ...
Hello, I have the following data in a column: 7 0 0 0 7 0 0 0 0 0 7 0 0 7 0 0 0 0 0 0 0 7 etc. The number of zero's between the 7's is random. I want a formula that would count the number of zeros between the 7's. Thanks, Ari Bari -- AriBari ------------------------------------------------------------------------ AriBari's Profile: http://www.excelforum.com/member.php...o&userid=25043 View this thread: http://www.excelforum.com/showthread...hreadid=388069 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells with length not equal to 7 | Excel Worksheet Functions | |||
| count cells that have *text1* and don't have *text2* | Excel Discussion (Misc queries) | |||
| Count cells in a column that contain dates | New Users to Excel | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
| How do I count shaded cells | Excel Worksheet Functions | |||
Threaded Mode
