Last seen: Apr 20, 2025
Rory Modified Mcode worked perfectly Alan
Rory, When I tried your Mcode, it errored looking for the Index Column that you created in the Group By. I separated those steps and this worked f...
There are 76 tables in this file. Do you know which ones you want?
1. Once imported to PQE, replace all null with zero 2. Set the data type for the columns in question to whole numbers 3. Add the columns (in a ne...
Pictures are really nice, but cannot manipulate data in them. Suggest you upload a sample file that we can work with. Don't ask us to recreate your ...
unable to assist. File is locked as read only and cannot change on my side. Macro will not run as it is blocked by security on your end. Sorry. Go...
Rather than have us reenter all your data into a spreadsheet, instead of a picture, please upload your file so that we can manipulate the data. Help ...
Attached file is unreadable. Please try again.
A sample workbook uploaded showing your current data and then indicating where you wish to place your results and what fields/cells you wish to track....
Maybe this: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Admin rate/Bas...
Does this look like what you are expecting. You did not give us a mocked up solution so I am guessing Name ...
In my mind the best method would be a date time field that indicates the updates. Then the latest record can be maintained and any earlier records rem...
How do you identify the latest entry. The only dates I see are listing and closing dates. Am I missing something?
What does the Mcode look like for the Parameter named JobName? It should look like this: let Source = Excel.CurrentWorkbook(){[Name="TableX"]}...
Change the ranges to tables