I have an excel sheet that has a three fields:
USER_ID | DATE_CREATED | TAGS
Tags applied to the items in the sheet vary quite a bit, and are set up like |
tag1 tag2 tag3...| within the field.
I want to get a list of all unique user IDs that acquired a certain tag at any point (
tagx), but did not have another, different tag at any point prior to that (
Given the variability in times when the users could have acquired
tagx, I'm not sure the best way to set this up.
How would I go about structuring my worksheet to filter for this information? I'm happy to set up additional helper columns that do testing, and to create pivottables.
EDIT: updated to better explain -- the fields included are just those fields that are available to me to complete this sort. The output that I'm looking for is, in any form, a list of all unique user IDs that acquired
tagx at any point, but did not have
tagy before they acquired
EDIT(1): here's a picture demonstrating what I'm looking for:
in this case I would want a way to grab ID #2 (and others like it) because it acquires and retains tagx on 1/3/2001 and does not have tagy before it
but I would want to exclude ID #1 because, although it also picks up and keeps tagx on 1/2/2001, it has tagy beforehand