All Questions
2
questions
3
votes
1
answer
2k
views
Make an array formula in excel calculate only on active rows
When excel calculates formulas over a column (e.g. a lookup), it's smart enough to only calculate until the last active row, rather than also running on all the blank rows.
With array formulas, it ...
- 774
0
votes
2
answers
2k
views
Excel array functions -- how to count non-blank cells over multiple worksheets?
I have an Excel workbook with numerous worksheets, some of them containing a numeric value in cell A1:
'DATA_1' 'DATA_2' 'DATA_3'
A A A
1 1....
- 638