10 aug 06 1459 hrs.
Greetings..
I am new to site..and to the use of Excel. I have recently started
putting information from the "Daily Racing Form" into an Excel
spreadsheet. I will use this data to work out simple and later complex
formulas for extracting desired data.
I have made cells long enough to hold each field, and there will be a
weekly entry. What I don't understand is how I will search each date
for a particular horse. It seems the formula could get lengthy.
How would I tell the program to search all the entries to a particular
"line"?, or do I just give each entry a "header" name?
Anyone with some good information and tips for this monumental task,
for getting started would be greatly appreciated.

Rick.


--
mehtalmann
------------------------------------------------------------------------
mehtalmann's Profile: http://www.excelforum.com/member.php...o&userid=37358
View this thread: http://www.excelforum.com/showthread...hreadid=570551

Just some thoughts for a galloping start to your venture <g ..

If the table is set-up in columns with col headers in row1, then immediately
you could use Data Filter Autofilter to filter the table, for example by
the particular horse's name. Just select the name from the autofilter
droplist under the col header: Horses. That will filter out all the lines
pertaining to that particular horse for your closer inspection

Try Debra's nice intro to autofilter (and more!) at her:
http://www.contextures.com/xlautofilter01.html
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mehtalmann" wrote:

10 aug 06 1459 hrs.
Greetings..
I am new to site..and to the use of Excel. I have recently started
putting information from the "Daily Racing Form" into an Excel
spreadsheet. I will use this data to work out simple and later complex
formulas for extracting desired data.
I have made cells long enough to hold each field, and there will be a
weekly entry. What I don't understand is how I will search each date
for a particular horse. It seems the formula could get lengthy.
How would I tell the program to search all the entries to a particular
"line"?, or do I just give each entry a "header" name?
Anyone with some good information and tips for this monumental task,
for getting started would be greatly appreciated.

Rick.


--
mehtalmann
------------------------------------------------------------------------
mehtalmann's Profile: http://www.excelforum.com/member.php...o&userid=37358
View this thread: http://www.excelforum.com/showthread...hreadid=570551

I hope you are not planning to place bets on your "results"!

"mehtalmann" wrote:


10 aug 06 1459 hrs.
Greetings..
I am new to site..and to the use of Excel. I have recently started
putting information from the "Daily Racing Form" into an Excel
spreadsheet. I will use this data to work out simple and later complex
formulas for extracting desired data.
I have made cells long enough to hold each field, and there will be a
weekly entry. What I don't understand is how I will search each date
for a particular horse. It seems the formula could get lengthy.
How would I tell the program to search all the entries to a particular
"line"?, or do I just give each entry a "header" name?
Anyone with some good information and tips for this monumental task,
for getting started would be greatly appreciated.

Rick.


--
mehtalmann
------------------------------------------------------------------------
mehtalmann's Profile: http://www.excelforum.com/member.php...o&userid=37358
View this thread: http://www.excelforum.com/showthread...hreadid=570551