rutgermons
asked on
two dimensional lookups (vlookup&hlookup)
Folks
See my sample excel sheet
I have data in sheet 1 showing my systems and the relevant activities over a calendar day
My question is , if I have more than 1 activities in one day per system this should be flagged as a conflict in sheet 2
so essentially I have 2 criterias that need to match i.e. system and date but it should only display the value if there are multiple activities
multiple activities are denoted by a comma separator i.e test,bounce (test is 1 activity and bounce is another)
kindly help build such a conflict report
conflict.xlsx
See my sample excel sheet
I have data in sheet 1 showing my systems and the relevant activities over a calendar day
My question is , if I have more than 1 activities in one day per system this should be flagged as a conflict in sheet 2
so essentially I have 2 criterias that need to match i.e. system and date but it should only display the value if there are multiple activities
multiple activities are denoted by a comma separator i.e test,bounce (test is 1 activity and bounce is another)
kindly help build such a conflict report
conflict.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
will follow up with a new request for this, i think this will work better with a macro and need this built into a macro