Featured Formulas

Lookup

Rank and score with INDEX and MATCH

In this example, the goal is to assign points based on a ranked score. The scores to rank are in column C, and the calculated Rank is in column D. Points are awarded based on the table in G5:H10. Both tblData (B5:E15) and tblPoints (G5:H10) are...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Date and time

NETWORKDAYS Function

The NETWORKDAYS function returns the number of working days between two dates, automatically excluding weekends (Saturday and Sunday) and optionally excluding holidays provided as a list of dates. NETWORKDAYS can be used to calculate employee benefits that accrue...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

This is the absolute best site for solving Excel problems and finding new ways to use Excel! I will sometimes search the web for a problem and I really don't know why I don't just come here first. I waste so much time trying to understand solutions on other sites. Then I come to ExcelJet and get a solution that I understand and BOOM my formula works! Thanks for this site. It is wonderful!!!
Michelle
Just a quick thank you for all the help you provide on your site. You help me every day.
Steve
So thanks again for your great tip. You are my go-to page for the excel function help, because your explanations are clear, concise, to the point and give you several viewpoints of the same function that helps you construct what you really need.
Stijn
More Testimonials

Get Training

We offer free resources and paid training.

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages