Find first data
 

Hello,

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

Thanks,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=380848

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=380848

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


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=380848

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

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

?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=380848

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


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=380848

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(B19,B1<11),"Yes",""), but fail =IF(B1=10,"Yes","").
:rolleyes:

Cheers!

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=380848

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

Thanks (and welcome back from vacation)

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=380848