By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

 


Dynamic Ranges

1.
=offset(reference, rows, cols, [height], [width])
2.
=OFFSET(Main!$E$10,0,0,COUNT(Main!$C$10:$C$365),1)
3.
reference = starting cell = Main!$E$10
4.
Rows = 0 ' start at specified row
5.
cols = 0 start at specified col
6.
Height = count (....)
7.
Width = 1 column

blog comments powered by Disqus