How to get below mentioned google sheet formula to work in EXCEL??
=countif(flatten(filter($C$3:$G$22,$B$3:$B$22=$J$2)),I4)
Reference image of the table and dashboard
I combined formula in google sheet to create a dashboard using COUNTIF,FLATTEN, and FILTER. Apparently its not working in Microsoft Excel. As flatten is not there, the alternative formula like TOROW, TOCOL and Transpose didn't seems to work at all.
So how should i approach to get similar result in Excel??