Last seen: Apr 30, 2025
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.
If I am understanding your needs correctly, then an easy means is with Power Query versus VBA Mcode let Source = Excel.CurrentWorkbook(){[N...