1. R

    Checking a range for specific criteria

    I'd like to put a formula in I2 that checks a2:h2 to see if this range of colors conforms to what I need. The range A2:H2 must contain at least: 1 Red 1 Orange 1 Yellow 3 Blue 1 Violet 1 [Any of the above colors] If the range conforms to the restrictions, I'd like it to leave a blank cell. If...

Some videos you may like

This Week's Hot Topics