There are over 50 locations that the individuals can be at. Looking at where they have been, each location has a code (A, B, or C) . The locations and codes are on sheet "ABCCodeListing."
I need the cell for "A" in worksheet 1, to state "A" if the individual has been at any location that denotes "A" within worksheet 2.
I thought I had this figured out, but I don't. Some individuals go from a location, to another, and back to the same location. My current formula causes them to cancel each other out when this happens.
Formula: =IFERROR(IF(MATCH(1,("A"=CodeList[A])*(($CZ3=CodeList[Org No])+($DA3=CodeList[Org No])+($DB3=CodeList[Org No])+($DC3=CodeList[Org No])+($DD3=CodeList[Org No])+($DE3=CodeList[Org No])+($DF3=CodeList[Org No])+($DG3=CodeList[Org No])+($DH3=CodeList[Org No])+($DI3=CodeList[Org No])),0)>0,"A",""),"")
I use CONTROL-SHIFT-ENTER at the end. It works... except for the repeats. Any ideas?
Solved by V. D. in 16 mins