Limit to nested IF(ISNUMBER(SEARCH)) functions?

[Ron Rosenfeld]

I have to wait until I get in the office tomorrow to double check with the
full list but I think this will work!

Thanks!!!

Jonathan

Let me know!!

There can still be problems if you have data that includes a high priority ID
that is embedded in such a way that it should not be counted. But you'll need
to examine your data set to see if that is a problem. (There are solutions
even for that).


--ron

 

[Jonathan Horvath]

Ron,

It worked. I have several entries that have multiple identifiers however
using the prioritization array allowed me to pluck the unique ones off one by
one and the remaining ones were all grouped into a single, and appropriate,
bucket.

thanks!

Jonathan

 

[Ron Rosenfeld]

Ron,

It worked. I have several entries that have multiple identifiers however
using the prioritization array allowed me to pluck the unique ones off one by
one and the remaining ones were all grouped into a single, and appropriate,
bucket.

thanks!

Jonathan

Good to hear. Thanks for the feedback.
--ron