Excel Cheat Sheet Help - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

Excel Cheat Sheet Help

Moderator: Baseball Moderators

Excel Cheat Sheet Help

Postby shortsavage » Fri Dec 24, 2004 5:27 pm

Hey everyone,

I am doing a highly formula-based cheat sheet on excel this year (you should try one, they are fun).

And I was wondering if anyone could help me out with one thing:

Is there a way to command excel to change ranks to simple numbers?
ex. 22nd --> 22

Let me know if you want any excel help to get your sheet started. I have found lookup functions to be quite helpful in my construction, and I would love to help anyone use them.
Mike Pelfrey > Matt Garza
shortsavage
General Manager
General Manager

User avatar
Cafe WriterWeb Supporter
Posts: 2946
Joined: 25 Aug 2003
Home Cafe: Baseball
Location: UC Davis

Postby Amazinz » Fri Dec 24, 2004 8:21 pm

=RANK(number, array, order)

number is the number to find the rank for.

array is the range or array of numbers to base the ranking on.

order is optional. 0 = descending order, >0 = ascending order.
Image
Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Postby shortsavage » Sat Dec 25, 2004 3:21 am

Thanks for the help Amazinz. Maybe I am just not understanding what the rank function does, but I don't think it is what I am looking for.

Hehe, I hardly know how to explain what I am after. It would probably end up being like a page-long essay that wouldn't really make sense. I'll just keep doing this the long way.
Mike Pelfrey > Matt Garza
shortsavage
General Manager
General Manager

User avatar
Cafe WriterWeb Supporter
Posts: 2946
Joined: 25 Aug 2003
Home Cafe: Baseball
Location: UC Davis

Postby e » Sat Dec 25, 2004 4:46 am

highlight the selected cells

Edit/Replace

Find all "nd" Replace with "" (leave replace blank) Replace all
Find all "st" Replace with "" (leave replace blank) Replace all
Find all "rd" Replace with "" (leave replace blank) Replace all
Find all "th" Replace with "" (leave replace blank) Replace all
e Beginner
Little League Legend
Little League Legend


Posts: 7
Joined: 29 Feb 2004
Home Cafe: Baseball

Postby shortsavage » Sat Dec 25, 2004 6:18 am

PERFECT!

Hehe, actually my girlfriend's dad helped me figure this out this evening.

Thanks for your help e.
Mike Pelfrey > Matt Garza
shortsavage
General Manager
General Manager

User avatar
Cafe WriterWeb Supporter
Posts: 2946
Joined: 25 Aug 2003
Home Cafe: Baseball
Location: UC Davis

Postby Amazinz » Sat Dec 25, 2004 11:33 am

Wow. I had no idea what you were asking. Must have been the egg nog... :-]
Image
Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters


Return to Baseball Leftovers

Who is online

Users browsing this forum: threelions and 4 guests

Forums Articles & Tips Sleepers Rankings Leagues


  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact