AboutPricing

Get instant live expert help on I need help with excel array formula not working

“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

    My array formula on the SAMS (ALL COURSES) sheet starting at '2018-2019 PROGRESS' with not pulling in the reference data from named table 'E_DATA' on the 'WORKDATA' sheet. Basically, my array formula is not working.
    Solved by D. B. in 28 mins
    I copied an array formula from internet which is not working anymore. Please look into this
    Solved by A. H. in 14 mins
    I cannot figure out why my array formula isn't working! The formula starts in A3 =IFERROR(MATCH($F3,SUMIF(OFFSET($H3,0,MATCH($G3,$H$1:$CV$1,0)-1,1,ROW($1:$161)),">0"),1)+1,"NOT STARTED")
    Solved by A. E. in 12 mins
    I need help with the Frequency function. The array is working but the values are a sum not a count for each bin.
    Solved by V. S. in 15 mins
    My modified formula from excel chat is not working.
    Solved by I. J. in 14 mins