Forum

Hi Alex, Yes, you can do it with this data but you need to change the layout of the table so that the first column is the name, the second column c...

Hi Wajahat, Welcome to our forum! In Excel 2013 Power Pivot doesn't have automatic date grouping or any way to group dates automatically. Instead, ...

Great to hear it's fixed, Kent! Diving on the GBR is amazing. I haven't been for nearly 20 years, so probably time I go back 🙂

No worries. Excel doesn't have any built in functionality for this. I'm sure someone could write some VBA to do it, but it wouldn't matter what too...

Hi Kenneth, Welcome to our forum! Unless there is a unique identifier between the transactions and bank receipts, like a transaction ID/invoice ...

Hi Usman, I did not "advise to post on our forum as I have solution to scrap emails as well." I said if you post your question on our forum I will ...

Hi Jacek, Add a custom column with this formula: = Source Expand the column to reveal the Name again. Here is the code: let Source = Ex...

Hi John, Welcome to our forum! Your question sounds similar to this. Although, it doesn't deal with different workbooks. I would avoid referencing ...

Hi Shashank, You can do this with a line chart which will draw a line between the two data points when displayed with a horizontal date axis. My...

Hi Usman, If you look at the source code of that web page (right-click the web page > view source) you can see it is protecting the email from b...

Hi Bax, I recommend you perform this calculation in Power Query because the Excel formula will only update when the file is opened. You can use: ...

So to be clear, the output is to close & load 250 separate tables? I'm not sure there's a limit to the number of queries as such and I don't u...

In the attached file I split the query into two: one for contacts and one for feedback. Then I merged them keeping only nulls. See query in file calle...

Hi Jacek, Well, 250 queries is a LOT! I'd try to find a better approach than creating 250 separate queries. Assuming you're then consolidating thes...

Hmmm, in that case all signs are pointing to a credentials issue i.e. the license you're logged into Excel with isn't compatible with the license that...