| Home > Forum Home > Automating Data Analysis Tasks > Conditional formatting of the last entry in the column only > Dynamically find the address of the last cell | Share |
Dynamically find the address of the last cell
Excel Help for Dynamically Find The Address Of The Last Cell in Automating Data Analysis Tasks
| Forum Topic | Login |
Dynamically Find The Address Of The Last Cell | Rate this: (3/5 from 1 vote) |
 | In this case, you need to change the formula to dynamically find the address of the last cell in the column. If the data is contiguous (it doesn't contain any blank cells) then you can use the following formula for column A: =IF(INDIRECT("A"&COUNTA(A:A))>0) | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Dynamically find the address of the last cell in the Excel Business Solutions Directory |