Two Blocks are separated by a line ... also u can use clear cell as
ending and event cell as starting of a block ..
the result sheet attached is manually made , since blocks were only 9
my problem is that i have thousands of such blocks ... i need ur help
Regards again


--
Dastard
------------------------------------------------------------------------
Dastard's Profile: http://www.excelforum.com/member.php...o&userid=34406
View this thread: http://www.excelforum.com/showthread...hreadid=547949