S
Steve F
I am importing data from tables into Excel from the
internet using the Web Query function. That part is no
problem. I'm testing this using football scores...my data
is actually very similar in format . Below is an
example:
SE MISSOURI 3
OHIO 17
Box Score
FINAL
EAST TENN. ST. 21
E. MICHIGAN 28
What I am looking for is a function that can find the
number that goes along with the text and put it into a
specific cell. i.e. Say I want SE Missouri's score to be
in cell A1. When you do a web query, you never know which
cell SE Missouri's score will show up in (web sites change
constantly). So I want the sheet to look for the text 'SE
Missouri' and pick off the number in the next cell. Can
anyone help?
Thanks,
Steve
(e-mail address removed)
internet using the Web Query function. That part is no
problem. I'm testing this using football scores...my data
is actually very similar in format . Below is an
example:
SE MISSOURI 3
OHIO 17
Box Score
FINAL
EAST TENN. ST. 21
E. MICHIGAN 28
What I am looking for is a function that can find the
number that goes along with the text and put it into a
specific cell. i.e. Say I want SE Missouri's score to be
in cell A1. When you do a web query, you never know which
cell SE Missouri's score will show up in (web sites change
constantly). So I want the sheet to look for the text 'SE
Missouri' and pick off the number in the next cell. Can
anyone help?
Thanks,
Steve
(e-mail address removed)