LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 23
Default Count Blocks of Data

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
blocks of data repeating eween New Users to Excel 4 March 29th 07 06:58 PM
averaging particular blocks of data robert111 Excel Discussion (Misc queries) 6 July 12th 06 02:41 PM
Copy Blocks Of Data SenojNW Excel Discussion (Misc queries) 2 August 9th 05 02:06 AM
How do I repeatedly transpose blocks of data? LucyW Excel Discussion (Misc queries) 3 August 1st 05 03:56 PM
Moving blocks of data in excel Yasmin Excel Discussion (Misc queries) 1 March 17th 05 10:39 PM


All times are GMT +1. The time now is 08:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"