Video 00033 Solution_identify rows if any in same group meet condition_V2

Requirement: Identify all items within a group if any of the items in that group meet a condition.

Solution: This time I use the SUMPRODUCT function for a quicker solution.  SUMPRODUCT can be used to count with conditions (within the same group).

 

Watch my YouTube video

 

Subscribe to my YouTube channel and learn more!

See my free templates here!

Leave a Reply

Your email address will not be published.