I have a table that shows sales for a date range. I'm running a query to pull invoices and dates and then using vlookups to pull in data from another worksheet. The system that I'm running the query on has custom payment methods available. I need to only show the payment methods that exist in the date range.
For example, for orders dated 3/2/20, there are invoices with Charge, Cash, Check, and Credit Card. I only want the table to show these 4 payment methods. However, the system also has the following payment methods available which could appear in any date range:
Visa, Mstr Card, Discover, AMEX, EBT, Paypal, MNY Order, Prepaid, Coupon.
Any help would be greatly appreciated.
For example, for orders dated 3/2/20, there are invoices with Charge, Cash, Check, and Credit Card. I only want the table to show these 4 payment methods. However, the system also has the following payment methods available which could appear in any date range:
Visa, Mstr Card, Discover, AMEX, EBT, Paypal, MNY Order, Prepaid, Coupon.
Any help would be greatly appreciated.