Exceljet (original) (raw)

Featured Formulas

Count total words in a cell

In this example, the goal is to count the total number of words in a cell. Excel doesn't have a dedicated function for counting words. However, with a little ingenuity, you can create a formula to perform this task using a combination of built-in functions. In newer versions of Excel, the best...Read more

Featured Functions

VLOOKUP Function

The Excel VLOOKUP function scans the first column in a table, finds a match, and returns a result from the same row. If VLOOKUP can't find a match, it returns a #N/A error or an "approximate match", depending on how it is configured. Because VLOOKUP is easy to use and has been in Excel for...Read more

Recent Articles

Seeded Random Number Generator in Excel

How to keep random numbers from changing in Excel? Excel's random functions like RAND and RANDARRAY recalculate every time you edit your worksheet, making it impossible to maintain stable random results. This article shows you how to build a seeded random number generator using Excel's...Read more

Topics By Category

User Testimonials

I appreciate the format of the website & the manner in which you present the formulae for each function, or solution. The solutions are well laid out, with a good break-down of the formulae and well written explanations. Exceljet has been my website of choice when looking for a solution, or an improvement, for a number of years.

Wow, what a fantastic site! I'm bookmarking it :) I googled today to find a solution to a perplexing problem, and fortunately your post on using match and index together came up. It was exactly what I needed. Thank you so much!

Let me tell you that I am uber happy to have found your classes on the internet – they combine huge knowledge with a great talent to explain and teach! I watched some of your free lessons before I invested money, and from what I have seen I can say that it's worth every penny!

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.