Welcome Guest
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
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

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.

 Page 1 of 1