Tag Archives: ARRAYTOTEXT

Quick #Excel 365 Tip – Combine values from a range of cells into comma separated text

Posted on October 2, 2023 by MF

Before 365, this needs to be entered into the CONCATENATE function one by one, not to mention the commas in between. With Excel 365, use the function: ARRAYTOTEXT. Bingo! Say the range of text resides in A1:A9. All you need … Continue reading →

Rate this:

Posted in Excel 365, Formula | Tagged | Leave a comment

Simple Basket Analysis – Formula approach with #Excel 365

Posted on March 25, 2023 by MF

The challenge – How many transactions with just Brand A and B together? In my previous post / video, I solved this problem with Power Query. If you are using #Excel 365, did you know you can solve this problem … Continue reading →

Rate this:

Posted in Excel 365, Excel in Action, Formula | Tagged , , , | Leave a comment