Thanks .. siege ...

forumlas can be tough at first ... but you'll get the hand of them real quick ... I think MLB has a list of them ...

an easy sample using excell...

I want to see home many homeruns per at ab each player got .. or HR/AB ... I'm sure you have heard of this ...

open up your excell and get to the top of the page for all batters ..

in the first blank column ... (should be row 1) type HR/AB ... Directly below that we are going to start a formula .. the 'CEll' (as they are called) should be blank (This should be row 2, column say ... k )so row 2 column K.

Now locate which column has HR's ..... maybe its coulmn F maybe it's coulmn H, for our example its H ... and locat which column has AB's ... our example will be coulmn G ... do ya folow me .. so far?

time to type a formula ...... back to our hypothectical coulmn ... 'K,2'

or column k ... row two written "K,2" in k,2 type =g2/h2

that's it ..hit enter the formula is AB/HR ... ,..

-------------------------------------------------------

filters .....

Click on the very top left hand side .. just above and to the left of A,1 ... the whole range of cells should go dark. ... On the tool bar, click data, then filter, then turn on the auto filter ...

each coulmn should now have a little arrow on it. it will allow you to sort real quick.... click top 10 and ask for the top 10 pct HRs ... play around here all ya want .... just don't delete info from here ...

Here you ask excell .... who are the batters that batted .300 and above .... had 15 hr's and a OBP of .400 ... It will tell ya .....using filters ...

if you get lost in the filters .... just go and turn the off and all your data is back to normal, then turn the 'auto filter' on again ...

hope this helps ...