Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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",""). 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 |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to find cell with data on a row | Excel Worksheet Functions | |||
compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
HOW DO I FIND DATA IN A TABLE BY LOOKING UP BOTH THE COLUMN AND R. | Excel Worksheet Functions | |||
Help with data not getting plotted | Charts and Charting in Excel |