Hello,
Formula:
=IFERROR(MATCH(0;($W$3:$W$159>=580)*($W$3:$W$159>0);0)-1;COUNTIF($W$3:$W$159;">0")+MATCH(0;(Results!$W$3:$W$159>=580)*(Results!$W$3:$W$159>0);0)-1)
the formula stopped at 0 value and blank cells... what can I do?
Best Regards!
Hello,
Formula:
=IFERROR(MATCH(0;($W$3:$W$159>=580)*($W$3:$W$159>0);0)-1;COUNTIF($W$3:$W$159;">0")+MATCH(0;(Results!$W$3:$W$159>=580)*(Results!$W$3:$W$159>0);0)-1)
the formula stopped at 0 value and blank cells... what can I do?
Best Regards!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks