How do I locate cells that contain a certain text?

E

EZ-XLS

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.
 
L

Luke M

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can UDF return a customized hyperlink? 3
Excel If a Cell Contains a Certain Text (From Another Table) 0
Find certain text in a cell 3
Counting cells that don't contain certain text 4
Count the number of AutoFiltered records 6
SUMIF with criteria "<>" & "=" 4
Conditional format when text contains using cell reference 4
How do I have a cell value define a dynamic named range? 15

Top