Forum

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...

This does not look like a PQ issue but rather a VBA type solution. I will be looking into writing some VBA code later today to address this. It ma...

Suggest you upload a sample of your data that is representative of your actual data. In this manner we can work with what you have and not Digalo's d...

I would do this with a parameter query as shown in the attached. Create a new table of key words. Insert a column and filter for the key word with a...

You need to preface the countifs function in VBA with Application.WorksheetFunction See this link for further understanding.