Thanks for participating in the 30XL30D challenge, that ended yesterday. My favourite Excel function in the series was INDEX -- I learned a few useful tricks while researching that one! How about you?
As I promised, here is a list of the 30 functions, with their rank in your voting. You can also download the 30XL30D Excel functions cheat sheet file, with the function descriptions and syntax, and links to the blog articles.
30 Excel Functions Ranking
| Rank | Function With Article Link |
| 1 | VLOOKUP |
| 2 | ADDRESS |
| 3 | INDIRECT |
| 4 | INDEX |
| 5 | OFFSET |
| 6 | MATCH |
| 7 | CHOOSE |
| 8 | AREAS |
| 9 | LOOKUP |
| 10 | CELL |
| 11 | FIND |
| 11 | HLOOKUP |
| 11 | TRANSPOSE |
| 14 | ERROR.TYPE |
| 15 | EXACT |
| 15 | SUBSTITUTE |
| 17 | CLEAN |
| 17 | REPLACE |
| 17 | SEARCH |
| 20 | CODE |
| 20 | T |
| 22 | INFO |
| 22 | N |
| 24 | COLUMNS |
| 24 | HYPERLINK |
| 26 | TYPE |
| 27 | TRIM |
| 28 | CHAR |
| 28 | FIXED |
| 28 | REPT |
Download the 30XL30D Cheat Sheet
You can download the 30XL30D Excel functions cheat sheet file, with the function descriptions and syntax, and links to the blog articles. The file is zipped, and in Excel 2007 file format, with no macros.
Buy the 30XL30D eBook Kit
If you want all of the 30XL30D content in an easy-to-use single reference file, you can buy the 30 Excel Functions in 30 Days eBook kit. Learn more about the 30 Excel functions in:
- a 150 page written lesson guide
- links to all the Excel video tutorials
- an Excel file with 100 function examples
For more details, please go to the 30 Excel Functions in 30 Days eBook kit page on the Contextures website.
_______________
For me INDEX is undoubtedly the most versatile function available in Excel and for that reason alone should really be #1 !
Thanks Luke, and thanks for all your contributions during the series.
Thanks for doing this Debra. It's quite an undertaking!
I'd like to second Luke's comment. As I was looking at the rankings I was thinking that Index is my #1. My appreciation of it has grown hugely in the last few months, especially in the area of replacing VLookups with Index/Match.
Thanks Doug! It was a big task, and rewarding to learn all the new formula tips and tricks.
Thanks a lot Debra.
The whole series of 30 detailed Functions was marvellous documented. Eventhough there are over 3xx functions in total, ther were in my humble opinion the most commonly used.
Carry on with these ideas
Regards
Francisco Romero