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.

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