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
Continue reading 30 Excel Functions in 30 Days: Conclusion