Excel Cheat Sheet Help - Fantasy Baseball Cafe 2014

## Excel Cheat Sheet Help

Moderator: Baseball Moderators

### Excel Cheat Sheet Help

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

Posts: 2946
Joined: 25 Aug 2003
Home Cafe: Baseball
Location: UC Davis

=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.

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

Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

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

Posts: 2946
Joined: 25 Aug 2003
Home Cafe: Baseball
Location: UC Davis

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
Little League Legend

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

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

Posts: 2946
Joined: 25 Aug 2003
Home Cafe: Baseball
Location: UC Davis

Wow. I had no idea what you were asking. Must have been the egg nog...

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

Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

### Who is online

Users browsing this forum: No registered users and 8 guests

Forums Articles & Tips Sleepers Rankings Leagues

Today's Games
Tuesday, Sep. 23
(All times are EST, weather icons show forecast for game time)

 • Kansas City at Cleveland(7:05 pm)
 • Baltimore at NY Yankees(7:05 pm)
 • NY Mets at Washington(7:05 pm)
 • Seattle at Toronto(7:07 pm)
 • Chi White Sox at Detroit(7:08 pm)
 • Philadelphia at Miami(7:10 pm)
 • Milwaukee at Cincinnati(7:10 pm)
 • Tampa Bay at Boston(7:10 pm)
 • Pittsburgh at Atlanta(7:10 pm)
 • St. Louis at Chi Cubs(8:05 pm)
 • Houston at Texas(8:05 pm)
 • Arizona at Minnesota(8:10 pm)
 • LA Angels at Oakland(10:05 pm)
 • San Francisco at LA Dodgers(10:10 pm)
 • Colorado at San Diego(10:10 pm)