When Should you Use the Hash Sign (#) in Excel Formulas?

When Should you Use the Hash Sign (#) in Excel Formulas?

I'll show you how and when you can use the # reference in Excel formulas and also when you shouldn't be using the hash reference in your excel formulas. The Hash sign or the pound sign (#) in an Excel formula allows you to easily reference an entire spilled range. You can only use this if you have Office 365 version and already have Excel functions like filter, unique and sort. This way Your Excel formula will automatically adjust and include the whole range as soon as the source data changes.

The Hash sign or the pound sign (#) in an Excel formula allows you to easily reference an entire spilled range. You can only use this if you have Office 365 version and already have Excel functions like filter, unique and sort. This way Your Excel formula will automatically adjust and include the whole range as soon as the source data changes. I'll show you how and when you can use the # reference in Excel formulas and also when you shouldn't be using the hash reference in your excel formulas.

If your Excel hash reference doesn't work, it's likely because you aren't referencing a spilled range in Excel. It can also be that you're using the reference inside an Excel table. In which case you'll see the spill error message (#spill). In this video I also explain why you can't use dynamic array functions like filter, sort and unique inside excel tables.

If you have Excel for Microsoft 365 you already have this functionality.

Link to my COMPLETE Excel Course about the NEW Dynamic Array functions: https://courses.xelplus.com/p/excel-dynamic-array-formulas

Time Stamps

  • 00:00 What does the Hash / Pound Sign mean in an Excel Formula
  • 06:08 Practical Example for the Hash Sign in Excel
  • 07:18 Why You Can't Use Filter, Sort and Unique in Excel Tables (and other ranges that spill)
  • 09:12 Bonus! How To Select Specific Part of a Spilled Range in Excel with Index Function

excel developer

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

How long does it take to develop/build an app?

This article covers A-Z about the mobile and web app development process and answers your question on how long does it take to develop/build an app.

Developer Career Path: To Become a Team Lead or Stay a Developer?

For a developer, becoming a team leader can be a trap or open up opportunities for creating software. Two years ago, when I was a developer, ... by Oleg Sklyarov, Fullstack Developer at Skyeng company

Offshore Software Development - Best Practices

To make the most out of the benefits of offshore software development, you should understand the crucial factors that affect offshore development.

Mobile Wallet Development, eWallet App Development, Digital Wallet App Development

Get the most of what the digital world has to offer with our innovative range of Digital wallet app development services. Enable your customers to store, send, and receive funds with ease and security. A customizable offering that is highly efficient and scalable.

Mobile Wallet Development, eWallet App Development, Digital Wallet App Development

Get the most of what the digital world has to offer with our innovative range of Digital wallet app development services. Enable your customers to store, send, and receive funds with ease and security. A customizable offering that is highly efficient and scalable.