Forum

Hi Nicholas, Please see the attached file which includes a chart of (some) of your data. You weren't clear what message you wanted to convey so I m...

Yep, 64-bit is required for bigger datasets. This thread talks about upgrading RAM as the next step. If your dataset isn't big then I recommend you...

Hi Paul, There's no set of rules that I'm aware of. Array formulas can perform multiple calculations on one or more of the items in an array. Somet...

Hi Blanka, In the file attached you'll see a Power Query solution, however it relies on the Premium values being unique, which I doubt they will be i...

Hi Angela, You lost me at "One row has the street address.", what do the other rows have? Can you please share some sample data so we can see your ...

Hi Paul, The solution is to find another way to achieve what those bottleneck formulas are doing. Avoiding array formulas if possible. Without f...

Hi Vanessa, Glad that worked. Aside from the course you can find the formula library online here: Plus the bonus eBook included with teh cou...

Hi syediomer, There are various tools you can use to extract the numbers you want to count, but the key is that the data must be consistent, and un...

Hi Tim, I'd use PivotTables instead of overly complicated formulas. Mynda

Hi Nikki, Thanks for your question. I've moved it to the Power Query MEMBERS group. This way I know you are a course member and will make sure you ...

Hi José, Your file isn't attached. After 'adding the files' you have to click the 'start upload' button to actually upload it. Mynda

It sounds like Power Query will be your saviour.You can learn more about what Power Query is and how it can help you on my course page here: Yo...

Hi Erica, Welcome to the forum. BTW I've moved your post to the Excel Expert members forum. There certainly is a better way to achieve what this...

Hi Deena, Thanks for providing your file. It makes it much easier to answer your question. When I see array formulas like this my instant reacti...

BTW, you use Csv.Document for Text or CSV files. Be careful with the case of this function.