Power Query to return records between two values

[Richard U]

I need to load records from another excel file into another based on a range of characters.

The user can enter the first and last into two cells with corresponding ranges (firstone, lastone)

From these two values, I need to do a power query to load in the data where the customer name is in between these two values.

So, if I have values 0 and D I would want all the customers who's names started with a number, or A, B, C, or D.

I am BRAND NEW to power query and haven't been able to figure this out yet.

 

[alansidman]

Suggest you upload sample data of your needs and show a mocked up solution that equates to your sample data. Please use XL2BB and no pictures as we cannot manipulate data in pictures. Additionally, if you think you are going to be using PQ regularly, then pick up the book, "M is for (Data) Monkey" which can be found in the MrE store. It is an excellent PQ primer.