Any Microsoft Excel Geeks out there??

Reply to Thread
  1. rejackt rejackt is offline

    Columbus, OH
    United States

    Posts: 598
    Joined: Mar 05

    Nov 7th, 2005 (11/7/2005 2:18pm)

    I dont know much about Excel. I did manange to make my own spreadsheet for tracking my poker play, mostly thru trial and error.

    I am currently working on a spreadsheet for football handicapping. I am having trouble finding a function that will run thru a series of results and then list them in chronological order.

    example:

    The handicapping spreadsheet takes alot of data that I input and then assigns a score to a team. So end result may look like this:

    (A1) Washington ....... (A2) 13.5
    (B1) Dallas ...............(B2) 15.3
    (C1) Houston ............(C2) 9.4
    (D1) carolina ............(D2) 10.2
    ect.....

    I would like to find a function that would run thru the numbers here (which is also in chart form) and display the team along with its score in chronological order from highest score to lowest.

    results i am hoping for:

    (A1) Dallas ..............(A2) 15.3
    (B1) Washington .......(B2) 13.5
    (C1) carolina ............(C2) 10.2
    (D1) Houston ...........(D2) 9.4

    reason I want to do this is because as the spreads for the games change thru the week, so will the score a team is assigned in the spreadsheet. right now I am physically writing them down in chronological order and would like to find a faster way.

    is this possible?
  2. scaryjerry scaryjerry is offline

    Indianapolis, IN
    United States

    Posts: 682
    Joined: Aug 05

    Nov 7th, 2005 (11/7/2005 3:34pm) in reply to rejackt

    you need to output your results in one area, then refrence those results, implement the sort function, and have another area that obtains the data from the sorted data.

    the button looks like and A ontop of a Z with an arrow going up or down (sort ascending/descending). THe command is located under data _> sort

    I actually use this function alot in my job, I always do the sort step manually but I you coul setup a macro to do it also.

    If you are confused and need help I only charge $55/hr but if you do a stars trasfer i will do it for $35/hr
Reply to Thread

Similar Threads