Hello All,
It might be a stupid question, I have below formula which I want to add in my VBA macro is not accepting the formula. What I need is macro to calculate this formula.
my excel formula is - =IF(SUMPRODUCT(--(D$3:D$7<>""),--ISNUMBER(SEARCH(D$3:D$7,A4))),"exclude","")
Anybody can help...