Sponsored Link

Sponsored Link

Sunday, September 14, 2008

Check if Value is Present in the give RANGE

Creating a formula that will return TRUE if each number in column E appears at least once in the range A2:C6.

If any of the specified numbers are missing, the formula will return FALSE.

Solution: Use AND and COUNTIF functions in the following Array formula:{=AND(COUNTIF(A2:C6,E2:E10))}


Xiteez Vyas said...

nice dude....!

Post a Comment