The formula is =IF(SUMPRODUCT(COUNTIF(A1:AS1,"*"&Keywords!$A$5:$A$78&"*")),"POTENTIAL", "")
It returns " potential" everytime it has a match.
The formula is =IF(SUMPRODUCT(COUNTIF(A1:AS1,"*"&Keywords!$A$5:$A$78&"*")),"POTENTIAL", "")
It returns " potential" everytime it has a match.
Please explain what you are trying to achieve?
Unable to understand for what purpose this formula is written in this way....
COUNTIF(A1:AS1,"*"&Keywords!$A$5:$A$78&"*")
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
looks like an array formula anyway?
Confirm by pressing CTRL-SHIFT-ENTER to activate the array. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL-SHIFT-ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks