Hello,
Currently working a spreadsheet where i am using the follow Formula that is bring up an #VALUE! Error.
=IF(ROWS(C$90:C90)<=SUM(N(Availability!C$1256:C$1305<>"")),INDEX(Availability!C$1256:C$1305,MATCH(SMALL(COUNTIF(Availability!C$1256:C$1305,"<="&Availability!C$1256:C$1305),SUM(N(Availability!C$1256:C$1305=""))+ROWS(Availability!$C$90:C$90)),COUNTIF(Availability!C$1256:C$1305,"<="&Availability!C$1256:C$1305),0)),"")
Using the same formula for actions in the spreadsheet but this one seems to be throwing out an error. Can anyone assist?
Thanks.
Bookmarks