Requirement: Identify all items within a group if any of the items in that group meet a condition.
Solution: I use functions VLOOKUP, AND to identify rows if a condition is met within the same group.
Watch my YouTube video
Video 00032 Solution_identify rows if any in same group meet condition
