exceljet.net Open in urlscan Pro
2600:3c00::f03c:91ff:fee7:ea6e  Public Scan

Form analysis
5 forms found in the DOM

GET /search

<form class="search-form" action="/search" method="get" id="header-search" accept-charset="UTF-8">
  <input type="text" name="keys" value="" placeholder="Search" size="15" maxlength="128" class="form-text search-text">
  <input type="submit" name="op" value="Search" class="form-submit search-submit">
</form>

---

GET /search

<form class="search-form" action="/search" method="get" id="header-search" accept-charset="UTF-8">
  <input type="text" name="keys" value="" placeholder="Search" size="15" maxlength="128" class="form-text search-text">
  <input type="submit" name="op" value="Search" class="form-submit search-submit">
</form>

---

GET /search

<form class="search-form" action="/search" method="get" id="hero-search" accept-charset="UTF-8">
  <input type="text" name="keys" value="" placeholder="Search" size="15" maxlength="128" class="form-text search-text">
  <input type="submit" name="op" value="Search" class="form-submit search-submit">
</form>

---

POST https://sendy.exceljet.net/subscribe

<form id="newsletter_signup" class="newsletter-signup-form" action="https://sendy.exceljet.net/subscribe" method="POST" accept-charset="utf-8">
  <label for="email" hidden="">Email</label>
  <input type="email" name="email" placeholder="email address" id="email" class="newsletter-signup-email text-input" required="">
  <div style="display:none;">
    <label for="hp">HP</label>
    <input type="text" name="hp" id="hp">
  </div>
  <input type="hidden" name="SignupLocation" id="SignupLocation" value="block">
  <input type="hidden" name="list" value="T1JX0z264YewQdKf7gXIig">
  <input type="hidden" name="subform" value="yes">
  <input type="submit" name="submit" id="submit" class="newsletter-signup-submit form-submit" value="Subscribe">
</form>

---

POST https://sendy.exceljet.net/subscribe

<form id="newsletter_signup_footer" class="newsletter-signup-form newsletter-signup-footer-form" action="https://sendy.exceljet.net/subscribe" method="POST" accept-charset="utf-8">
  <label for="email" hidden="">Email</label>
  <input type="email" name="email" placeholder="email address" id="newsletter-signup-footer-email" class="newsletter-signup-footer-email newsletter-signup-email text-input" required="">
  <div style="display:none;">
    <label for="hp">HP</label>
    <input type="text" name="hp" id="newsletter-signup-footer-hp">
  </div>
  <input type="hidden" name="SignupLocation" id="newsletter-signup-footer-SignupLocation" value="footer">
  <input type="hidden" name="list" value="T1JX0z264YewQdKf7gXIig">
  <input type="hidden" name="subform" value="yes">
  <input type="submit" name="submit" id="newsletter-signup-footer-submit" class="newsletter-signup-footer-submit form-submit" value="Subscribe">
</form>

---

Text Content

Skip to main content
 * Login

Cart
Exceljet
 * Training
 * Videos
 * Functions
 * Formulas
 * Shortcuts
 * Articles


Cart
 * Login

Main menu toggle
 * Training
 * Videos
 * Functions
 * Formulas
 * Shortcuts
 * Articles

 * Login


LEARN EXCEL WITH CLEAR EXAMPLES AND BITE-SIZED VIDEOS.




FEATURED FORMULAS

Dynamic array


DETAILED LET FUNCTION EXAMPLE

In this example, we have a simple set of data in B5:D16 that includes ID, Name,
and Points. The goal is to generate a custom message for any name in the list by
entering a valid ID in cell G5. The message uses the name from column C and the
points in column D like this:

...Read more

Count


COUNT CELLS BETWEEN TWO NUMBERS

Lookup


LOOK UP ENTIRE COLUMN

More Formulas


FEATURED VIDEOS

Excel Shortcuts
3:02


EXCEL RIBBON SHORTCUTS

Core Pivot
2:41


HOW TO REFRESH DATA IN A PIVOT TABLE

Core Formula
3:18


HOW TO DO A TWO-WAY LOOKUP WITH INDEX AND MATCH

Excel Shortcuts
3:22


EXCEL SHORTCUTS ON A MAC

More Videos


FEATURED FUNCTIONS

Statistical


RANK FUNCTION

The Excel RANK function assigns a rank to a numeric value when compared to a
list of other numeric values. Use RANK when you want to display a rank for
numeric values in a list. It is not necessary to sort the values in the list
before using RANK.


CONTROLLING RANK ORDER...READ MORE

Dynamic array


XLOOKUP FUNCTION

Dynamic array


TEXTAFTER FUNCTION

More Functions


RECENT ARTICLES

Formulas


XLOOKUP VS INDEX AND MATCH

For many years, INDEX and MATCH have been the go-to solution for difficult
lookup problems in Excel. While more complicated to configure, the
two-function combination of INDEX + MATCH is flexible and powerful. But now
that...Read more

Formulas


XLOOKUP VS VLOOKUP

Formulas


WHY SUMPRODUCT?

Formulas


HOW TO CONCATENATE IN EXCEL

Formulas


WHAT IS AN ARRAY FORMULA?

More Articles


TOPICS BY CATEGORY


FORMULAS

 * Count
 * Sum
 * Average
 * Dynamic array
 * Min and Max
 * Lookup
 * If
 * Grouping
 * Conditional formatting
 * Data validation
 * Rank
 * Round
 * Date and Time
 * Date series
 * Text
 * Financial
 * Geometry
 * Workbook
 * Internet
 * Names
 * Percentage
 * Random
 * Range
 * Tables
 * Errors
 * Miscellaneous


SHORTCUTS

 * File
 * Ribbon
 * General
 * Tables and Filters
 * Drag and Drop
 * Navigation
 * Selection
 * Active Cell
 * Extend Selection
 * Select Special
 * Cell edit mode
 * Entering data
 * Formatting
 * Number Formatting
 * Borders
 * Formulas
 * Grid Operations
 * Pivot Tables
 * Workbook
 * Dialog boxes
 * Other


FUNCTIONS

 * Logical
 * Date and time
 * Lookup and reference
 * Text
 * Dynamic array
 * Engineering
 * Financial
 * Information
 * Math
 * Trigonometry
 * Statistical
 * Web
 * Database


USER TESTIMONIALS

You have a great concept and your courses are the best, most efficient and fun I
had until now. I use my new skills every day.
Annick
I am a software engineer with 10+ years of programming experience, but I had to
learn advanced Excel material for a new job that used it primarily and I found
the official Microsoft documentation a bit vague and uninstructive until I found
your website, which helped me implicitly understand a lot about the internal
workings of Excel's formulas and matrix treatments through your explanations and
examples.
Jay
This is probably the best explanation I've ever read of an excel function, and
I've read a lot! Thank you for making it so clear and easy to understand!!! :)
Marie
More Testimonials


NEWSLETTER SIGN-UP

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


CONQUER EXCEL

Email
HP


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


Exceljet
Quick, clean, and to the point


RESOURCES

 * Training
 * Videos
 * Functions
 * Formulas
 * Shortcuts
 * Articles


ABOUT US

 * About
 * Testimonials
 * Topics
 * Contact


NEWSLETTER SIGN-UP

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
Email
HP
© 2012-2023 Exceljet. Terms of use
 * Visit our Twitter page