... contains the following::
A
---------------
warm
noise
term
wreck
The formula to paste in column B of Sheet1 is as follows:
=SUMPRODUCT(--ISNUMBER(SEARCH(Sheet2!$A$1:$A$4,Sheet1!A1)))>0
Where:
SumProduct( ...
Thought I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum:
Quick Count
=INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&"")))
...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.