Hello Friends, first time posting here as I have a frustrating excel problem at work. It is so simplistic to explain that I couldn't find any similar problems on the search tools here, and I am sure the answer will be embarrassing to me. I have a example sheet to provide but it says I can't attach documents here. Here is an explanation:
An example sheet would contain a list of unique ITEM ID's (and thus rows, in column A) that have either an X, Y, or Z TYPE (in column B) and may or may not have a SEQUENCE # (in column C). I am trying to find the items (rows) with a Y or Z type that matches Sequence # with an item that has an X type in column B. Once I have only those items (rows) with Y or Z type with matching sequences to X types on my screen, I want to manually edit the types of these to X with a end result of matching items' sequence numbers to X type in column B. Some rows don't have sequence numbers so are blank, but all rows in the data set have a type.
It sounds like any other column filter procedure: just filter to type X in column B, filter out blank sequence numbers in column C, then go back to column B's to uncheck Type X and then check Y and Z. The problem happens here: When I checkbox Y and Z with X's sequence numbers already filtered in column C, Excel shows ALL non-blank items with any sequence #'s and not just the ones that match Type X items like I wanted. Thus I am forced to find manual ways to record X Type Items and their sequence numbers and then manually match them to Y and Z type items.
What is the most optimal way around this, and what tool am I not using here? Once I learn my issue I plan to implement it into a macro immediately because it is frustrating to me.
Thank you in advance for helping me with my petty excel problem.
An example sheet would contain a list of unique ITEM ID's (and thus rows, in column A) that have either an X, Y, or Z TYPE (in column B) and may or may not have a SEQUENCE # (in column C). I am trying to find the items (rows) with a Y or Z type that matches Sequence # with an item that has an X type in column B. Once I have only those items (rows) with Y or Z type with matching sequences to X types on my screen, I want to manually edit the types of these to X with a end result of matching items' sequence numbers to X type in column B. Some rows don't have sequence numbers so are blank, but all rows in the data set have a type.
It sounds like any other column filter procedure: just filter to type X in column B, filter out blank sequence numbers in column C, then go back to column B's to uncheck Type X and then check Y and Z. The problem happens here: When I checkbox Y and Z with X's sequence numbers already filtered in column C, Excel shows ALL non-blank items with any sequence #'s and not just the ones that match Type X items like I wanted. Thus I am forced to find manual ways to record X Type Items and their sequence numbers and then manually match them to Y and Z type items.
What is the most optimal way around this, and what tool am I not using here? Once I learn my issue I plan to implement it into a macro immediately because it is frustrating to me.
Thank you in advance for helping me with my petty excel problem.