How to Find the Last Column of Data in Excel Office 365?
Tags: findthelastcolumn, excelpreface
Published: 2021-03-24 04:06:07

---
title: How to Find the Last Column of Data in Excel Office 365?
published: true
date: 2021-03-23 09:59:44 UTC
tags: Findthelastcolumn,ExcelPreface
canonical_url: https://geekexcel.com/how-to-find-the-last-column-of-data-in-excel-office-365/
---

In this article, we will learn the instructions to **find the last column of data in Excel Office 365** with an example. To do this, we are going to use the **[Min](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)**, **[Column](https://geekexcel.com/use-column-function-in-microsoft-excel-365-simple-methods/)**, and **[Columns](https://geekexcel.com/steps-to-use-columns-function-in-microsoft-excel-365-simple-way/)** function in Excel. Let’s follow the instructions and achieve the task. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Find the Last Column of Data in Excel:

You need to follow the below steps to get the data which is located in the last column in the Excel spreadsheet.

- In the below screenshot, you can see that the example data regarding student’s marks.
- Here, we will find the last column number and last test date.

![Example data](https://geekexcel.com/wp-content/uploads/2021/03/pYNZIS2z0S.png)<figcaption id="caption-attachment-22623">Example data</figcaption>

- To get the last column, you need to apply the below formula.

**=[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)([COLUMN](https://geekexcel.com/use-column-function-in-microsoft-excel-365-simple-methods/)(range1))+[COLUMNS](https://geekexcel.com/steps-to-use-columns-function-in-microsoft-excel-365-simple-way/)(range2)-1**

**range1 –** This argument given as the named range for the array **A1:AA4** in the above formula.

**range2 – ** It contains the range of the given data.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_ZyATmdp9YE.png)<figcaption id="caption-attachment-22624">Enter the formula</figcaption>

- After applying the above formula, you need to **click** the **Enter** key.
- Now, you will get the last column as shown in the below image.

![Last column](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_vC4wJcNKJY.png)<figcaption id="caption-attachment-22625">Last column</figcaption>

- Then we need to get the value from the last non-blank cell.
- To get that, you need to use the below-given formula.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(range,1,Cell that contains last column)**

- After entering the formula, you need to **press** the **Enter** button to get the output as shown in the below image.

![Result](https://geekexcel.com/wp-content/uploads/2021/03/Result-31.png)<figcaption id="caption-attachment-22627">Result</figcaption>

## Verdict:

To sum up, I hope that this article helped you to know the instructions to **find the last column of data in Excel Office 365** with an example. Drop your **suggestions/feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)**

**Read Also:**

- [Excel Formulas to Highlight the Cells that contain Certain Value!!](https://geekexcel.com/excel-formulas-to-highlight-the-cells-that-contains-certain-value/)
- [Split Data into Multiple Worksheets with Set of Rows using Macros (VBA) in Excel!!](https://geekexcel.com/split-data-into-multiple-worksheets-with-set-of-rows-using-macros-vba-in-excel/)
- [Excel Formulas to Build Gantt Chart by Week ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-build-gantt-chart-by-week-easy-tutorial/)