Website banner for SpreadsheetClass.com

Learn to automate and grow your business with spreadsheets

  • Home
  • Google Sheets
    • Tutorial
    • Formulas
    • Tips
    • Formatting
    • Error Troubleshooting
  • Cheat Sheet
    • Free PDF Cheat Sheet
    • Ultimate Cheat Sheet spreadsheet
  • Templates
    • Microsoft Excel Templates
    • Google Sheets Templates
  • Dashboards
    • Full dashboards course
    • Basic dashboard tutorial
  • Youtube
  • About
    • About
    • Contact
    • Hire an expert
    • LinkedIn
  • Excel
    • All Excel Lessons
    • Excel Templates
    • Excel Formulas
    • Excel Tips
    • Excel Formatting
    • Excel Error Troubleshooting
  • Home
  • Google Sheets
    • Tutorial
    • Formulas
    • Tips
    • Formatting
    • Error Troubleshooting
  • Cheat Sheet
    • Free PDF Cheat Sheet
    • Ultimate Cheat Sheet spreadsheet
  • Templates
    • Microsoft Excel Templates
    • Google Sheets Templates
  • Dashboards
    • Full dashboards course
    • Basic dashboard tutorial
  • Youtube
  • About
    • About
    • Contact
    • Hire an expert
    • LinkedIn
  • Excel
    • All Excel Lessons
    • Excel Templates
    • Excel Formulas
    • Excel Tips
    • Excel Formatting
    • Excel Error Troubleshooting
  • Home
  • Google Sheets
    • Tutorial
    • Formulas
    • Tips
    • Formatting
    • Error Troubleshooting
  • Cheat Sheet
    • Free PDF Cheat Sheet
    • Ultimate Cheat Sheet spreadsheet
  • Templates
    • Microsoft Excel Templates
    • Google Sheets Templates
  • Dashboards
    • Full dashboards course
    • Basic dashboard tutorial
  • Youtube
  • About
    • About
    • Contact
    • Hire an expert
    • LinkedIn
  • Excel
    • All Excel Lessons
    • Excel Templates
    • Excel Formulas
    • Excel Tips
    • Excel Formatting
    • Excel Error Troubleshooting

Using the Excel COLUMN function with an array to create a horizontal list of numbers with a single formula

Written by Corey Bustos Updated on November 4, 2021 in

Example of using the Excel COLUMN function with an array to create a horizontal list of numbers with a single formula

Related Posts:

  • How to automatically create a series of values in Excel
  • Using array formulas to apply a formula to an entire…
  • Microsoft Excel Lessons and Templates
  • 5 formulas that combine columns in Excel
  • How to automatically create a series of values in…
  • How to filter based on a list in Excel
Tweet Share Pin It Print

Welcome to Spreadsheet Class!

Corey Bustos

My name is Corey, I have been building spreadsheets for companies for over 7 years, I was a data specialist at an online school for 5 years, and I created this website to help people learn how to use spreadsheets.

Read More
  • Contact
  • About
  • Hire an expert
  • Video course
  • Formula cheat sheet
  • YouTube lessons
Example image of Google Sheets cheat sheet for sidebar
Free Dashboards image for the footer

Dashboard video tutorial

  • Hire an expert
Connect with me on LinkedIn
Free Cheat Sheet image for the footer
Copyright © 2023 Silver Sky, LLC. Silver Sky, LLC is a limited liability company headquartered in Colorado, USA. — Designed by WPZOOM
Contact
 
Privacy Policy
 
Terms and Conditions