exceljet.net

• charset: utf-8
• property: og:description content: Quick, clean, and to the point. Videos and resources to help you work faster in Excel.
• property: og:image content: https://exceljet.net/sites/default/files/Exceljet_Social_1200x630.png
• property: og:title content: Exceljet
• property: og:type content: website
• property: og:url content: https://exceljet.net/
• name: description content: Quick, clean, and to the point. Videos and resources to help you work faster in Excel.
• name: twitter:card content: summary
• name: twitter:description content: Quick, clean, and to the point. Videos and resources to help you work faster in Excel.
• name: twitter:image content: https://exceljet.net/sites/default/files/Exceljet_Social_1200x630.png
• name: twitter:image:height content: 630
• name: twitter:image:width content: 1200
• property: og:image:width content: 1200
• name: twitter:site content: @exceljet
• name: twitter:title content: Exceljet
• name: twitter:url content: https://exceljet.net/
• name: viewport content: width=device-width, initial-scale=1
• property: og:image:height content: 630
• equiv: origin-trial content: AlK2UR5SkAlj8jjdEc9p3F3xuFYlF6LYjAML3EOqw1g26eCwWPjdmecULvBH5MVPoqKYrOfPhYVL71xAXI1IBQoAAAB8eyJvcmlnaW4iOiJodHRwczovL2RvdWJsZWNsaWNrLm5ldDo0NDMiLCJmZWF0dXJlIjoiV2ViVmlld1hSZXF1ZXN0ZWRXaXRoRGVwcmVjYXRpb24iLCJleHBpcnkiOjE3NTgwNjcxOTksImlzU3ViZG9tYWluIjp0cnVlfQ==
• equiv: origin-trial content: Amm8/NmvvQfhwCib6I7ZsmUxiSCfOxWxHayJwyU1r3gRIItzr7bNQid6O8ZYaE1GSQTa69WwhPC9flq/oYkRBwsAAACCeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXN5bmRpY2F0aW9uLmNvbTo0NDMiLCJmZWF0dXJlIjoiV2ViVmlld1hSZXF1ZXN0ZWRXaXRoRGVwcmVjYXRpb24iLCJleHBpcnkiOjE3NTgwNjcxOTksImlzU3ViZG9tYWluIjp0cnVlfQ==
• equiv: origin-trial content: A9nrunKdU5m96PSN1XsSGr3qOP0lvPFUB2AiAylCDlN5DTl17uDFkpQuHj1AFtgWLxpLaiBZuhrtb2WOu7ofHwEAAACKeyJvcmlnaW4iOiJodHRwczovL2RvdWJsZWNsaWNrLm5ldDo0NDMiLCJmZWF0dXJlIjoiQUlQcm9tcHRBUElNdWx0aW1vZGFsSW5wdXQiLCJleHBpcnkiOjE3NzQzMTA0MDAsImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9
• equiv: origin-trial content: A93bovR+QVXNx2/38qDbmeYYf1wdte9EO37K9eMq3r+541qo0byhYU899BhPB7Cv9QqD7wIbR1B6OAc9kEfYCA4AAACQeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXN5bmRpY2F0aW9uLmNvbTo0NDMiLCJmZWF0dXJlIjoiQUlQcm9tcHRBUElNdWx0aW1vZGFsSW5wdXQiLCJleHBpcnkiOjE3NzQzMTA0MDAsImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9
• equiv: origin-trial content: A1S5fojrAunSDrFbD8OfGmFHdRFZymSM/1ss3G+NEttCLfHkXvlcF6LGLH8Mo5PakLO1sCASXU1/gQf6XGuTBgwAAACQeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXRhZ3NlcnZpY2VzLmNvbTo0NDMiLCJmZWF0dXJlIjoiQUlQcm9tcHRBUElNdWx0aW1vZGFsSW5wdXQiLCJleHBpcnkiOjE3NzQzMTA0MDAsImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9

• Skip to main content
• Login
• Cart
• http://exceljet.net/
• Training
• Videos
• Functions
• Formulas
• Shortcuts
• Articles
• http://exceljet.net/#
• Ask the chatbot
• Dynamic array
• Read more
• Sum by quarter
• Sum
• Calculate running total
• The UNIQUE function
• Dynamic Array Formulas
• How to enter custom patterns with the fill handle in Excel
• Core Excel
• 30 Excel Shortcuts in 12 minutes
• Excel Shortcuts
• Excel shortcuts on a Mac
• Text
• Read more
• concatenates
• REGEXREPLACE Function
• Dynamic array
• REGEXTEST Function
• Shortcuts
• Read more
• Formulas
• Arrays in Excel
• How to replace Excel's DATEDIF function
• Seeded Random Number Generator in Excel
• Modeling the 4 Percent Retirement Rule in Excel
• Count
• Average
• 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
• 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
• Logical
• Date and time
• Lookup and reference
• Engineering
• Financial
• Information
• Math
• Trigonometry
• Statistical
• Web
• Database
• Testimonials
• About
• Topics
• Contact
• Donate
• Terms of use

• https://twitter.com/exceljet

            Domain Name: EXCELJET.NET
Registrar: Tucows Domains Inc.
Domain Status: client transfer prohibited
Domain Status: client update prohibited
Creation Date: 2012-12-16T16:15:58Z
Registry Expiry Date: 2027-12-16T16:15:58Z
Updated Date: 2024-11-20T20:51:44Z
Name Server: NS1.LINODE.COM
Name Server: NS2.LINODE.COM
Name Server: NS3.LINODE.COM
Name Server: NS4.LINODE.COM
Name Server: NS5.LINODE.COM
REGISTRAR Contact: Tucows Domains Inc.
>>> Last update of RDAP database: 2026-03-18T00:51:23Z         

			# As a condition of accessing this website, you agree to abide by the following
# content signals:

# (a)  If a Content-Signal = yes, you may collect content for the corresponding
#      use.
# (b)  If a Content-Signal = no, you may not collect content for the
#      corresponding use.
# (c)  If the website operator does not include a Content-Signal for a
#      corresponding use, the website operator neither grants nor restricts
#      permission via Content-Signal with respect to the corresponding use.

# The content signals and their meanings are:

# search:   building a search index and providing search results (e.g., returning
#           hyperlinks and short excerpts from your website's contents). Search does not
#           include providing AI-generated search summaries.
# ai-input: inputting content into one or more AI models (e.g., retrieval
#           augmented generation, grounding, or other real-time taking of content for
#           generative AI search answers).
# ai-train: training or fine-tuning AI models.

# ANY RESTRICTIONS EXPRESSED VIA CONTENT SIGNALS ARE EXPRESS RESERVATIONS OF
# RIGHTS UNDER ARTICLE 4 OF THE EUROPEAN UNION DIRECTIVE 2019/790 ON COPYRIGHT
# AND RELATED RIGHTS IN THE DIGITAL SINGLE MARKET.

# BEGIN Cloudflare Managed content

User-agent: *
Content-Signal: search=yes,ai-train=no
Allow: /

User-agent: Amazonbot
Disallow: /

User-agent: Applebot-Extended
Disallow: /

User-agent: Bytespider
Disallow: /

User-agent: CCBot
Disallow: /

User-agent: ClaudeBot
Disallow: /

User-agent: CloudflareBrowserRenderingCrawler
Disallow: /

User-agent: Google-Extended
Disallow: /

User-agent: GPTBot
Disallow: /

User-agent: meta-externalagent
Disallow: /

# END Cloudflare Managed Content

#
# robots.txt
#
# This file is to prevent the crawling and indexing of certain parts
# of your site by web crawlers and spiders run by sites like Yahoo!
# and Google. By telling these "robots" where not to go on your site,
# you save bandwidth and server resources.
#
# This file will be ignored unless it is at the root of your host:
# Used:    http://example.com/robots.txt
# Ignored: http://example.com/site/robots.txt
#
# For more information about the robots.txt standard, see:
# http://www.robotstxt.org/robotstxt.html
#
# For syntax checking, see:
# http://www.robotstxt.org/checker.html

User-agent: *
Crawl-delay: 10
# Directories
Disallow: /core/
Disallow: /profiles/
# Files
Disallow: /README.md
Disallow: /web.config
# Paths (clean URLs)
Disallow: /admin
Disallow: /comment/reply
Disallow: /filter/tips
Disallow: /node/add
Disallow: /user/register
Disallow: /user/password
Disallow: /user/login
Disallow: /user/logout
Disallow: /checkout
Disallow: /version/
Disallow: /bundles/
        

Technical SEO

On-Page SEO

Content and UX