PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

FIND LAST FILLED CELL IN EXCEL

INTRODUCTION

This situation comes around many times when we are programming any application in VBA or we are making any reports in Excel when we need to find out the last filled cell in a row or a column.
We’ll discuss different type of cases related to the issue and find out different ways to sort them out.
The article will discuss the solutions with examples.

 

finding last filled cell in a row

This is very frequent situation when we need to find out the last cell in a row or column. We can get any value against the last cell. Let us find out the ways by which we can do this.

SOLUTION 1-find last cell IN ROW using lookup

Usually , it is hard to run a check of different cells using the functions in Excel but even then we have a few which help in this regard. One of such function is LOOKUP. It runs from one end to other and looks up the value needed and return the value from the column which we have specified.

Suppose We have the following data in a row and we need to find the last filled value.

12 1212233454563445
FIND LAST CELL IN A ROW
FIND LAST FILLED CELL
EXCEL: FIND THE LAST USED CELL IN A ROW

finding last filled cell in a COLUMN

As in the case of the row, sometimes we need to find out the value of the last filled cell in a column too. In this solution we’d find the way to find out the value of last filled cell in a column or any value corresponding to the last filled cell in a column.

SOLUTION 1-find last cell IN A CELL using lookup

Let us try to check the cells of a column and find out the last filled cell in a column. Usually this kind of task is easily done in VBA but we will still try in Excel. We’ll take help of LOOKUP function in this as this is a very basic function for looking up a value in a given table and it runs throughout the range.

Suppose We have the following data in a column.

RANGE
1
 
3
23
4
54
5
 
 
 
 
6

 

FIND LAST FILLED CELL IN A COLUMN
EXCEL:FIND LAST USED CELL IN A COLUMN

finding last USED ROW in a SHEET

Let us find out the last used row in a column i.e. the row which contains the last data in a row. We can take the leads from the above examples of finding the last used cell in a column.

SOLUTION 1-find last USED ROW IN A SHEET

Let us try to check the cells of a column and find out the last filled cell in a column. Usually this kind of task is easily done in VBA but we will still try in Excel. We’ll take help of LOOKUP function in this as this is a very basic function for looking up a value in a given table and it runs throughout the range.

Suppose We have the following data in a column.

RANGE
1
 
3
23
4
54
5
 
 
 
 
6

 

FIND LAST FILLED CELL IN A COLUMN
EXCEL:FIND LAST USED CELL IN A COLUMN

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: