Check if a number exists in a range?

  • Thread starter Thread starter gkaste
  • Start date Start date
G

gkaste

Is there any way (hopefully easy, no code) to check if a number exist
in a range?

For example, A1 to A5 contains the numbers 1, 2, 3, 4, 5. I want t
check if range A1:A5 contains, for example 2. Just have a true o
false return.


Thanks
 

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

Check if text exists within a cell range and return logical vaule - possible? 2
Excel formula, sum the value cell and if empty cell left blank 0
Sum number range ignoring numbers formatted as text 0
Check if Combination exists 3
Return latest value from data range 4
Multiple if statements with multiple conditions 4
selecting a range 2
Calculating the number of unique values with a range 3

Back
Top