Welcome Guest
Log In | Register )
You last visited December 10, 2016, 9:06 pm
All times shown are
Eastern Time (GMT-5:00)

Searching for a string of numbers in xcel

Topic closed. 1 reply. Last post 8 years ago by CARBOB.

Page 1 of 1
PrintE-mailLink
Avatar
New Member

United States
Member #62904
July 12, 2008
5 Posts
Offline
Posted: January 8, 2009, 10:51 am - IP Logged

Searched the forum and couldn't find an answer to my question...  Not even sure if this is possible.

I would like to be able to search a  number from a list and have the entire string returned..

for example:

Say I have a whole bunch of past draws listed by date:

      A             B      C        D       E         F       G

1-3-2004       5     11      15      21      33     22

1-6-2004       8     15      23      32      43     31

1-9-2004       10   14      19      39      51     44

1-11-2004     5     9        22       31     54     2

 

Now, say I want to search on the number 5 as the first number and have the date

and entire string returned like this:

1-3-2004       5     11     15     21     33     22

1-11-2004     5     9       22     31     54     2

 

Keep in mind, I have many months of past draws and would like to be able to

search on only the first number (B column).. 

 

is this possible?  Can someone come up with a formula to do this?

Many thanks for the help

Bandito

    CARBOB's avatar - FL LOTTERY_LOGO.png
    ORLANDO, FLORIDA
    United States
    Member #4924
    June 3, 2004
    5913 Posts
    Offline
    Posted: January 8, 2009, 11:05 am - IP Logged

    Searched the forum and couldn't find an answer to my question...  Not even sure if this is possible.

    I would like to be able to search a  number from a list and have the entire string returned..

    for example:

    Say I have a whole bunch of past draws listed by date:

          A             B      C        D       E         F       G

    1-3-2004       5     11      15      21      33     22

    1-6-2004       8     15      23      32      43     31

    1-9-2004       10   14      19      39      51     44

    1-11-2004     5     9        22       31     54     2

     

    Now, say I want to search on the number 5 as the first number and have the date

    and entire string returned like this:

    1-3-2004       5     11     15     21     33     22

    1-11-2004     5     9       22     31     54     2

     

    Keep in mind, I have many months of past draws and would like to be able to

    search on only the first number (B column).. 

     

    is this possible?  Can someone come up with a formula to do this?

    Many thanks for the help

    Bandito

    Goto  MrExcel.com, lots of help there. I get most of my formulas from them.