| Home > Forum Home > Analyzing Corporate Financial Data > help with blank cells in range > INDIRECT with COUNTA | Share |
INDIRECT with COUNTA
Excel Help for Indirect With Counta in Analyzing Corporate Financial Data
| Forum Topic | Login |
Indirect With Counta | Rate this: (4/5 from 2 votes) |
 | You're right. The OFFSET returns the value - not the address reference. Try instead: INDIRECT("B1:B" & TEXT(COUNTA(B:B),"#")) | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for INDIRECT with COUNTA in the Excel Business Solutions Directory |