In this example, the goal is to count orders (rows) where the state is Texas ("TX"), the amount is greater than $100, and the month is March. In this case, we can't use COUNTIFS, because COUNTIFS is a...Read more
The TEXTSPLIT function splits a text string with a given delimiter into multiple values. The output from TEXTSPLIT is an array that will spill into multiple cells in the workbook.
Arrays are now a core part of how Excel formulas work. This article explains what arrays are, how array formulas work, and how dynamic arrays have changed the game. Includes practical examples, tips for inspecting arrays, a guide to the new array functions in Excel,
Whenever I am looking for specific formulas and functionality I always end up here. Your descriptions and steps are hands down the best out there. Really appreciate the work you have put in!
Rory
This is the absolute best site for solving Excel problems and finding new ways to use Excel! I will sometimes search the web for a problem and I really don't know why I don't just come here first. I waste so much time trying to understand solutions on other sites. Then I come to ExcelJet and get a solution that I understand and BOOM my formula works! Thanks for this site. It is wonderful!!!
Michelle
I want to thank you for this superb website on Excel. Way of your teaching in all videos as well as articles is absolutely brilliant. Also design of your website is awesome.
Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.