Reply to thread

Message

<blockquote data-quote="Heretic Apostate" data-source="post: 831681" data-attributes="member: 696">Yeah, ISERROR is a great function!In a spreadsheet I made recently, I wanted to give the users the option of searching for text strings that may occur anywhere (if at all) within text of indeterminate length.So, I used:IF(ISERROR(SEARCH(text searched for,text searchedin)),not there message,string found message)That way, they were able to search for individual words or parts of words or whatever.Turned out to be useful.&nbsp; That spreadsheet took a process that could take up to several hours, was labor-intensive, and very error-prone, and reduced it to less than 15 minutes, all automated, and all calculations are well controlled.&nbsp; They absolutely love it. <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile&nbsp; &nbsp; :)"&nbsp; data-smilie="1"data-shortname=":)" />Of course, it's clunky and bloated, but what the hey.&nbsp; It's at least an order of magnitude better than doing it by hand.&nbsp; And I gave it to them for free, as a Christmas present. <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile&nbsp; &nbsp; :)"&nbsp; data-smilie="1"data-shortname=":)" /></blockquote>

[QUOTE="Heretic Apostate, post: 831681, member: 696"] Yeah, ISERROR is a [b]great[/b] function! In a spreadsheet I made recently, I wanted to give the users the option of searching for text strings that may occur anywhere (if at all) within text of indeterminate length. So, I used: IF(ISERROR(SEARCH(text searched for,text searchedin)),not there message,string found message) That way, they were able to search for individual words or parts of words or whatever. Turned out to be useful. That spreadsheet took a process that could take up to several hours, was labor-intensive, and very error-prone, and reduced it to less than 15 minutes, all automated, and all calculations are well controlled. They absolutely love it. :) Of course, it's clunky and bloated, but what the hey. It's at least an order of magnitude better than doing it by hand. And I gave it to them for free, as a Christmas present. :) [/QUOTE]

Verification