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


BASIC FILTER EXAMPLE

In this example the goal is to return rows in the range B5:E15 that have a
specific state value in column E. To make the example dynamic, the state is a
variable entered in cell H4. When the state in H4 is changed, the formula should
return a new set of records. This is a perfect...Read more

Lookup


XLOOKUP WITH BOOLEAN OR LOGIC

Dynamic array


LIST UPCOMING BIRTHDAYS

More Formulas


FEATURED VIDEOS

Core Charts
3:42


HOW TO PLOT SURVEY DATA IN A BAR CHART

Core Formula
3:18


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

Dynamic Array Formulas
3:21


FILTER FUNCTION WITH TWO CRITERIA

Dynamic Array Formulas
2:55


FILTER WITH DYNAMIC DROPDOWN LIST

More Videos


FEATURED FUNCTIONS

Dynamic array


TEXTAFTER FUNCTION

The Excel TEXTAFTER function extracts text that occurs after a given delimiter.
When multiple delimiters appear in the text, TEXTAFTER can return text that
occurs after the nth instance of the delimiter. TEXTAFTER can also extract text
after a specific delimiter when counting...Read more

Dynamic array


VSTACK FUNCTION

Dynamic array


LET 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

I frequently use the resources you provide here on your website, and wanted to
thank you for the awesome work you are doing. It is very well done, has great
breadth, and lays out complex topics in an understandable way.
Chase
After many years of subscription, I still enjoy your updates and emails.
Will
Very satisfied with the product! It has made me more efficient at work!
Evan
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
 * Donate


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