Forum Discussion
Helper ILooking to merge only non-filtered values
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.
3 Replies
- ToddChitt
Super User
>> 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"
?
Spudder112I 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.
