Excel 2010 Preview #1: New Rank Function RANK.AVE

RANK.AVE will average the rank score when there is a tie!! See the new Excel 2010 RANK.AVE and RANK.EQ functions.

Category:

Science & Technology

Tags:

• Excel
• 2010
• Preview
• RANK
• function
• that
• averages
• when
• there
• is
• tie
• Mike
• Gel
• excelisfun
• Girvin
• Highline
• Community
• College

[dabj24]

Is there a way to rank teams in excel like they do in sports. For example, if there are two divisions and the top 2 teams of each division are ranked 1st and 2nd and the rest of the teams are based on their winning percentage, is there a way to do that in excel using the rank function?

[ExcelIsFun]

I am not sure what your question sis, but I have a bunch of videos that show many ways to rank. try these:

Excel Magic Trick 707: RANK with Criteria - SUMPRODUCT

Excel Magic Trick 337: RANK function 10 Examples

[oburcrod]

hi mike,,,,do you know what does slice comand do? it is located in the insert ribbon, at the end of the row

Good job mike,,,keep coming videos..!!

[ExcelIsFun]

See this video I made:

Excel 2010 Preview #4

Slicer does Pivot Tables and Tables.

Slicer is a beautiful user interface for filtering.

[ExcelIsFun]

Try this video:

Excel Magic Trick 337: RANK function 10 Examples

[robw1031]

oh well, i guess i am destine to use 2003 for the next 40 years or until it no longer works in the OS i am using........... What gets my goat is even in windows 7 you can still have a windows 95 appearance but they refuse to give us that option in office oh well thx for the info..........

[ExcelIsFun]

No. Even though many people for the last few years have said that they would like to see menus, Microsoft refuses to go back.

[robw1031]

Did they by chance give us an option to go back to the old menus and tool bars?