AboutPricing

Get instant live expert help on countblank function in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.
< Go Back

    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
    Solved by M. J. in 15 mins
    Need help in excel formula - IF function
    Solved by I. H. in 17 mins
    Need help using countifs function in excel
    Solved by O. Q. in 21 mins