Find first data

**EMoe** · 06-21-2005, 08:59 AM

Hello,

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

Thanks,
EMoe

**Ron Coderre** · 06-21-2005, 09:16 AM

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

Returns the position of the first "Y" in the list of cells (1 through 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?

Ron

**EMoe** · 06-21-2005, 09:56 AM

Not quit! Lets try a different approach.

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

Thanks,
EMoe

**Ron Coderre** · 06-21-2005, 10:18 AM

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

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

?

Ron

**EMoe** · 06-21-2005, 12:03 PM

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

**swatsp0p** · 06-21-2005, 12:11 PM

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","").