Tag Archives: array formula

Dear Analyst 133-banner

Dear Analyst #133: Find or check if a cell contains text from a list of values or partial matching text in a list (3 methods)

There are times when a problem nags at you like a pebble in your shoe. Even when you’re not working on the problem itself, you’re thinking about the problem which make it even worse. Rarely do I come across a Google Sheets/Excel task I cannot solve with formulas, but this one evaded my extensive knowledge […]

Excel Formula Question #3 from Modeloff 2013 Released with Explanation (3 of 4)

Calling all Excel formula geeks, fans, and enthusiasts out there. It’s that time again! See if you have what it takes to complete the 3rd Excel challenge in this riveting series from the Modeloff 2013 award ceremonies. The 2nd challenge from last week’s post involved using array-entered formulas. Challenge #3 builds off the awesomeness of array-entered […]

Excel Formula Question #2 from Modeloff 2013 Released with Explanation (2 of 4)

Are you ready for another Excel formula challenge from the Modeloff 2013 group challenge? Question #2 requires some knowledge about array formulas and just some flat out formula building creativity. Many thanks to Dan Mayoh for providing the answers to us. Dan recently launched his consulting business called Fintega Pty Ltd; the site is still under construction […]