Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a list of data. Occasionally, there are periods where no data is
recorded and the string "NoData" appears. I would like 2 single cell formulae that determine the number of times that "NoData" appears and the number of blocks of "NoData". The first is easily done with a counif statement, but the second is not as easy. I have several long columns of data, so I'd rather not use a second column for each column of data (it would greatly increase the size of the spreadsheet). A single cell formula would be best. Is there such a formula? The logic I would use is: if the cell = "NoData" AND the previous (or following) cell < "NoData" then count it. I can't figure out how to make that work. Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
blocks of data repeating | New Users to Excel | |||
averaging particular blocks of data | Excel Discussion (Misc queries) | |||
Copy Blocks Of Data | Excel Discussion (Misc queries) | |||
How do I repeatedly transpose blocks of data? | Excel Discussion (Misc queries) | |||
Moving blocks of data in excel | Excel Discussion (Misc queries) |