Last seen: Jun 7, 2025
crossposted: Suggest you read:
crossposted: and
Would be really helpful if you supplied some sample data in an attached file. Probably only need 6-8 records that are representative of your actual f...
How about giving us a sample table and your query and then tell us what is not happening that you want to happen or what is happening that you don't w...
Duplicate Posting
Built a parameter query where I made the Input to Take the filter value in the main query. File is attached for your review.
If you still think you need to use VBA and Vlookup after reading Philip's post then look at this link for a quick tutorial
You could build a parameter query where you input the Date (Using the Unix Date/Time value) each time you wish to run the report in PQ. Here is a lin...
Look at this link for an alternative means that will probably work for you with many items
I'm thinking that a Pivot Table would be the answer, but not knowing what you want your end result to look like it is difficult to offer up a solution...
crossposted:
Keep them has numbers until you close and load to Excel. Once back in Native Excel, format as Currency. The following is from Microsoft: ...
See attached file for my solution.
For the make and Model, still in PQ #"Added Conditional Column14" = Table.AddColumn(#"Renamed Columns - Make and Model", "Make", each if Text.C...