| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Max number of consectutive blanks in a range
I have this formula in column G
=IF(SUMIF(Montana!$A$3:$A$700,C3,Montana!$N$3:$N$7 00)0,SUMIF(Montana!$A$3:$A$700,C3,Montana!$N$3:$N $700),"") In Column H, I like to count the maximum number of consecutive blanks in that entire range. Meaning, there may 5 consective blanks, then 3, then 18, then 7. I'd like 18 to be returned. Thanks, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Delete blanks between a range and populate only the names inthe given range | Excel Discussion (Misc queries) | |||
| Naming Consectutive Excel Tabs | Excel Worksheet Functions | |||
| selecting non consectutive cells/rows/columns in excel 2007 | Excel Discussion (Misc queries) | |||
| countif with two sets of non consectutive ranges at the same time | Excel Worksheet Functions | |||
| copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
Threaded Mode
