thank you everyone for your great support
Hi Miguel, i have tried your suggestion VBA coding, in one of my orginial sheet but nothing appearing. Regards, Atif
Hi Jim, sorry, my mistake. i havent looked at the helper sheet. just looked at the helper sheet and there are lots of formula's. appreciate if y...
Jim, i have tried to use your formula "=COUNTIF(Helper!2:2,3)" in original sheet and get error. is there something changed any where? Regards, A...
thank Jim, Yes Miguel, you are right, 26 consecutive empty cells in a row, (26/3 = 8.6 ...) Regards, Atif
Dear Miguel, yes, we need to count the consecutive 3 cells in a row to be consider as 1, but when the empty cells reached to 6 (which is dubble of ...
thank you Purfleet and Miguel for your reply, yes we need to count consecutive 3 blank rows and consider as "1". now the sheet provide answer 2 for fi...
thanks Purfleet, but here we need to separate counting if the 3 blank cells in a row, so we need to counts, how many times the 3 or more blank rows...