ExcelBanter - find last row in column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - find last row in column (https://www.excelbanter.com/excel-discussion-misc-queries/230582-find-last-row-column.html)

Mike Milmoe

find last row in column

I have data that is consolidated in columns (up to 15 columns). I want to
put a total at the end of the rows, which is not a problem. What I need
however is to delete the columns that don't get used (say if they only
consolidate 10 columns). I know there is a way to find last cell of data for
a column, but is their the same functionality to find the last cell in rows?

Thanks!

Mike

CLR

find last row in column

Maybe this.....
=IF(COUNT(A1:A15)=15,SUM(A1:A15),"")

Vaya con Dios,
Chuck, CABGx3

"Mike Milmoe" wrote:

I have data that is consolidated in columns (up to 15 columns). I want to
put a total at the end of the rows, which is not a problem. What I need
however is to delete the columns that don't get used (say if they only
consolidate 10 columns). I know there is a way to find last cell of data for
a column, but is their the same functionality to find the last cell in rows?

Thanks!

Mike

All times are GMT +1. The time now is 08:51 PM.