I have 13 columns, A to M, and each cell will either contain the number one or be left empty. In column "N", for each row, I need to know if there are 6 consecutive columns which are empty.
I hope I have explained myself clearly. Please let me know if you need any more details.
Many thanks, Alan.