Looking to merge only non-filtered values

[Spudder112]

Hello,

In one query I have:

Date Key

Product Key

Cost

Existing?

I want to filter Exisitng? to "Y" (Y/N column) and then merge the remaining values to another query. Is filtering and then merging all that is needed? I tried that and got different values, but want to see if there is something else I am doing wrong.

[ToddChitt]

>> I want to filter Exisitng? to "Y" (Y/N column) and then merge the remaining <<

Is it not simply a filter like this: [Existing] <> "Y"

?

[Spudder112]

I had clicked on the filter at the top of the "Existing?" column and removed "N". 

Then I went to the destination sheet, and tried merging the data onto it. That is where it did not work.

To clarify, I am using the date and product key (combined into a helper column) to merge the cost into a different query. However, the data arriving into the other query (from this Date-Product-Cost-Existing query) is unfiltered.

[Spudder112]

Nevermind, usually it prompts me if the field I am trying to merge by is a different data type. However, this time it did not, and I just had to change the data type of a field for it to work.