enter a value for a cell according to a criteria in an other cell

  • Thread starter Thread starter mango
  • Start date Start date
M

mango

I am a newbie and I want to do the following. For every cell in column
A with any "5"character in the cell, to have the value "YES'' in
Column D on the same row. You help is much apreciated. Thanks in
advance.
 
In d1 and drag down

=IF(ISERROR(FIND("5",A1,1)),"","YES")

Mike





- Show quoted text -
Click to expand...

thanks Mike,

How about if I only am looking for a character in the cell
value?......
''......
;
 
You must log in or register to reply here.

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

Named cells in an array to a column and to a row 3
Selecting a cell according to the cell value 2
Search for empty cells and move cells next to 10
Array with many cells from a row but not in order or together 11
Insert Value into cell automatically when new rows are created/inserted 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Remove specific cells in a column. 2
Dynamic Offset from an Application.Goto cell = Date or Time 10

Back
Top