Last seen: Sep 15, 2025
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
These lines of code are made inactive as you have them commented out. Remove the single quote from the front of each of the lines of code. 'S...
Look at this link Also if you google :Excel Templates for Amortization with changing rates there are multiple resources
If I understood you correctly, I first grouped your table by Personal Reference and Max Date. I then merged (joined) that table back onto the origina...
Will be easier to provide a solution if you provide a sample worksheet and a mocked up solution of what you desire. 8-10 records should be sufficient...
I would use a different approach. With Power Pivot, build a measure to concatenate the values. ie. =CONCATENATEX(Range,Range[Name],", ") ...
I am a bit confused as to what you want the end result to look like. Please mock up a solution so we have a better idea.
crossposted: Please read:
Is it possible that the path names and directories on the new laptop are not exactly the same as on the older computer?
While Riny has provided a formula solution, you could also achieve similar results by combining (concatenating) the columns with a delimiter such as ...
No file attached. Please try again.
You have not provided any Order IDs in your DB. Without this information, a lookup via a parameter query is not possible.