Find first data

E

EMoe

Hello,

I need a formula that will find the first Y in a range of cells from
A1:A10.

Thanks,
EMoe
 
R

Ron Coderre

I'm not sure what you want to do with the information once you ge
it....but, maybe one of these will help:

Returns the position of the first "Y" in the list of cells (1 throug
10):
=MATCH("Y",A1:A10,0)

Returns the cell address of the first cell containing "Y":
=ADDRESS(MATCH("Y",A1:A10,0),1)

Am I on the right track here?

Ro
 
E

EMoe

Not quit! Lets try a different approach.

How do I write a formula; if cell B1 is greater than 9 but less tha
11, return Yes as the value?

Thanks,
EMo
 
R

Ron Coderre

Here's what you asked for:
=IF(AND(B1>9,B1<11),"Yes","")

But, isn't that just:
=IF(B1=10,"Yes","")

?

Ron
 
E

EMoe

Thanks Ron,

Yes your right, its the same as the 2nd formula, but I just used that
as an example. The first formula lets me adjust the ranges as needed.

Regards,
EMoe
 
S

swatsp0p

Hi, Ron: You are assuming the OP is dealing strictly with integers.
e.g. 9.001 and 10.999 would also meet his criteria
=IF(AND(B1>9,B1<11),"Yes",""), but fail =IF(B1=10,"Yes","").
:rolleyes:

Cheers!

Bruce
 
R

Ron Coderre

Just trying to make sure EMoe got what was needed....not just what was
asked for.

Thanks (and welcome back from vacation)

Ron
 
Top