I want to build a formula that locates the cells that CONTAIN a certain text
and either replace the WHOLE cell with something else or return a defined
result in another cell.

The first part is pretty much what autofilter does when a custom filter is
defined.

Depending on what your layout looks like, and without examples, sounds like
you want to use a combination of FIND/SEARCH, MATCH, or INDEX.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"EZ-XLS" wrote:

I want to build a formula that locates the cells that CONTAIN a certain text
and either replace the WHOLE cell with something else or return a defined
result in another cell.

The first part is pretty much what autofilter does when a custom filter is
defined.

I would look in the vba help for FINDNEXT.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"EZ-XLS" wrote in message
...
I want to build a formula that locates the cells that CONTAIN a certain
text
and either replace the WHOLE cell with something else or return a defined
result in another cell.

The first part is pretty much what autofilter does when a custom filter is
defined.