How do I use Countif to test if a sequence appears within an array ?
peter.PNG
As you can see from my screenshot I tried COUNTIF(A28:A31,B28:B30)
to see if the sequence Peter, glen, greg appears within the array A28:A31.
How do I use Countif to test if a sequence appears within an array ?
peter.PNG
As you can see from my screenshot I tried COUNTIF(A28:A31,B28:B30)
to see if the sequence Peter, glen, greg appears within the array A28:A31.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks