Saving Array formula result in a Varible

[pankajkaushik12]

Dear Scholars,

I want to write a function with range as a parameter.

There are multiple values written from Jan to Dec in each column ,i want to find whether there is any gap(blank) cell exist between values.

The formula will take column d4 to v4 as parameter and will return "Yes/No if there is any GAP exist"

for example GAP(D4:V4) Result should be "Yes/No"

i have a formula to find out non blank cells for this , this is an array formulls =MIN(IF(D4:V4<>"",COLUMN(D4:V4))), this is an array formulla , i want to put the same in VBA Code.

pls help

warm regards
Pankaj

[Glenn Kennedy]

Is this what you want????


=IF(COUNTIF(B2:T2,"")>0,"Yes","No")

copied down.

[pankajkaushik12]

No Glen , my concern is to find out whether any value is missing between two months or not...

for example if in march month value is not present and it exist in month before and after that then i will consider this as Gap, refer my
attached file for more clarity.

thanks for your help in advance!