Checking The Frequency of Multiple Values In A Range
Creating a formula that will return TRUE if each of the numbers in column H (Numbers to Check) appears at least once in Range A2:C6.
In case any of the numbers are missing, the formula will return FALSE.
Using the COUNTIF and AND functions, in an array formula as follows:
(To create Array formula: select the cell after typing the formula,press F2 and then press Ctrl+Shift+Enter)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1