| Home > Forum Home > Analyzing Corporate Financial Data > help with blank cells in range > OFFSET and COUNTA for dynamic range | Share |
OFFSET and COUNTA for dynamic range
Excel Help for Offset And Counta For Dynamic Range in Analyzing Corporate Financial Data
| Forum Topic | Login |
Offset And Counta For Dynamic Range | Rate this: (3/5 from 1 vote) |
 | In this case, you can create a dynamic range by using the OFFSET and COUNTA functions. To do so, replace B2:B164 with OFFSET($B$2,0,0,COUNTA($B:$B),1). | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for OFFSET and COUNTA for dynamic range in the Excel Business Solutions Directory |