[Keylogger]

Hi

I have the following table in the cell A:

A |

2 |
3 |
4 |
2 |
2 |

And I need to check if there's number 2 in all cells of A (ex: A1, A2, A3..etc)
I tried so far:
=IF(FIND("2"; A1:A4; 1); "0"; "1")

But it gives me error.

[modi123_1]

Typically it's a great thing to post said error..


Over all though use the 'search' to see if you get a number or an undefined value for your cell and search term.

=ISNUMBER((SEARCH("2",B249)))

[Keylogger]

That was an example. I'm not dealing with numbers. I'm dealing with text.

The error that shows is just "Error value".

Edit: If I only choose 1 cell, it works fine..but I need to find a range of cells.

This post has been edited by Keylogger: 11 September 2012 - 11:40 AM

[modi123_1]

... then use the range selector with the colon...

=ISNUMBER((SEARCH("2",B248:B252)))

[Keylogger]

Nope.
I want something like this:

=IF((SEARCH("Gold";D3:D5;1));"Gold Yes";"Not Gold")

[modi123_1]

I don't understand how to respond to that. Did you find your answer, or what? where did that chunk of code come from?

[Keylogger]

I found the solution. Only I need to do was checking with function COUNTIF() firstly.

Thank you.