Forum

Hi, You write "the field is empty". What field are you referring to? Is the Excel query by any chance connecting to a local table/data range? Once ...

Why not use 1 and 0 to mark an account as Active and Inactive. Then you can filter Active accounts by selecting 1.

Not sure I follow., but I believe you need to use SUMIF here, not COUNTIF. The attached file has two variants. hopefully one of these is the one you n...

You omitted to add a link to your post on MrExel. Found it and added it below so that people answering on this forum can check if an answer has come i...

Please see attached. Once you have connected to the table and set the correct data type to Time for the time column, you can group by ID and Time. Ple...

Hi David, the attached file contains the PT's you want. Needed to transfer the dates to real dates using Text-to-columns and grouped the dates in t...

I believe I fixed the Debit/Credit issue for the General Ledger sheet, but to get the corresponding narratives in place is a different issue. One I ha...

Sorry! Can't help you with that.

That I'm not aware of. Sorry.

The picture did not come through. Please try again and don't forget to push the "Start Upload" button before submitting a reply.

100 queries seem a lot. Perhaps it will help if you group the queries in the Queries & Connections window. Use some logic that enables you to f...

Unless I'm totally mistaken, yes you need to connect PQ to all tables/ranges you want to use. It creates a query, but that doesn't really matter. Or w...

Hi Howard, I created a slightly different layout with some helper columns. It make the formulae easier to follow, I think. See if I understood your...

On the Data ribbon, Get Data, Legacy Wizards, From Text as shown in the picture.

To be honest, I have a hard time following where all the numbers come from. Especially the Budget Overrun column in the Contingency table and the mean...