LinkBack URL
About LinkBacks
Thanks Donkey and n=b!
that's exactly what I needed. Donkey, you're right. I needed a search in rather than exact match. Just trying to educate myself: what does the count function do exactly?
Thanks Donkey and n=b!
that's exactly what I needed. Donkey, you're right. I needed a search in rather than exact match. Just trying to educate myself: what does the count function do exactly?
SEARCH will either return a Number (found) or a #VALUE! error (not found)
COUNT identifies how many numbers exist in the array of values passed to it.
In this instance the array of values within the COUNT is the two SEARCH results.
It follows that if either SEARCH returns a Number the resulting COUNT will be > 0.
We can use the COUNT result to execute the appropriate part of the IF given only 0 = FALSE (all other numbers = TRUE)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks