Dear All,
Kindly guide me what correction required so formula does work.
Regards,.Range("H2").FormulaArray = "=SUM(IFERROR(1/COUNTIF($F$2:$F$" & Lastrow,IF($F$2:$F$" & Lastrow <F2,$F$2:$F$" & Lastrow)),0))+1"
pnnaik
Dear All,
Kindly guide me what correction required so formula does work.
Regards,.Range("H2").FormulaArray = "=SUM(IFERROR(1/COUNTIF($F$2:$F$" & Lastrow,IF($F$2:$F$" & Lastrow <F2,$F$2:$F$" & Lastrow)),0))+1"
pnnaik
Last edited by pnnaik; 04-01-2018 at 11:02 AM.
It gives compile error expected end of statement.
Thanks,
pnnaik
Notice that the debugger highlights the comma after Lastrow. You are trying to concatenate l variable (Lastrow) calculated elsewhere with strings in several places, but you re missing several &" delimiters:
Please Login or Register to view this content.
Ben Van Johnson
You have fixed the issue.
I was using following formula. It was required to change to variable row. So I was trying with variable.
Is it same one or different?.Range("H2").FormulaArray = _
"=SUM(IFERROR(1/COUNTIF($F$2:$F$134,IF($F$2:$F$134<F2,$F$2:$F$134)),0))+1"
Thanks,
pnnaik
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks