Hi,Can you please help me with my Filter question?
I'm trying to filter an Inventory Excel Sheet with 20 Thousand items listed. Each Part # has its unique ID# (Stored in ColB). There are many source locations and each Source Location has a Loc ID(Alpha)# from Q-Z (This Loc# is stored in ColM). There can be the same part with many entries according to their individual source Locations but it can't be that the same Part# should be both, from Locations Q thru W and also from Locations X thru Z.
So for example Part # 2300 can show many rows of assorted Locations, Loc# Q thru Loc# W or it can show many rows from assorted Locations from Loc# X thru Z,
but it can't show from Loc# Q, R, S, T, U,V,W and also Loc# X, or, Y, or Z.
I need to filter out those "mistaken entries" in ColM where the Same Item # (in ColB) was entered from the 2 contradictory zones. Does this require a Function or is it a simple Filter?
I'm trying to filter an Inventory Excel Sheet with 20 Thousand items listed. Each Part # has its unique ID# (Stored in ColB). There are many source locations and each Source Location has a Loc ID(Alpha)# from Q-Z (This Loc# is stored in ColM). There can be the same part with many entries according to their individual source Locations but it can't be that the same Part# should be both, from Locations Q thru W and also from Locations X thru Z.
So for example Part # 2300 can show many rows of assorted Locations, Loc# Q thru Loc# W or it can show many rows from assorted Locations from Loc# X thru Z,
but it can't show from Loc# Q, R, S, T, U,V,W and also Loc# X, or, Y, or Z.
I need to filter out those "mistaken entries" in ColM where the Same Item # (in ColB) was entered from the 2 contradictory zones. Does this require a Function or is it a simple Filter?