Here are some problems that our users have asked and received explanations on
Simple formula using isblank or countblank doesn't keep relative cell references when I copy the formula, but the formula works fine if I type it in manually. This is true regardless of whether the data being referenced is in a table or not. So strange! Help!
Solved by G. Q. in 13 mins
=INDEX(A1:A17,SMALL(IFERROR(ROW(INDIRECT("1:"&COUNT(A1:A17)+COUNTBLANK(A1:A17)))*IF(A1:A17="","",1),""),ROW(INDIRECT("1:"&COUNT(A1:A17))))) Can you help me explain in words what this formula is doing?
Solved by B. J. in 25 mins
In EXCEL 2016 HOUR Function in SQL fails with "Hour is not a recognized function