andrewbroadway
New Member
On the tab named "Dashboard" I am playing with the offset function to return a range of rows from the "Missed Time - AD Usage' tab.
=OFFSET('Missed Time - AD Usage'!$B$5,0,1,92,1)
That is the formula I am using. So I am starting at B5, moving 0 rows down, 1 column to the right, the height is 92 and I only want 1 column.
Yes instead of returning #VALUE, the formula actually gives me whats in cell C15.
I am so frustrated! What am I doing wrong?
=OFFSET('Missed Time - AD Usage'!$B$5,0,1,92,1)
That is the formula I am using. So I am starting at B5, moving 0 rows down, 1 column to the right, the height is 92 and I only want 1 column.
Yes instead of returning #VALUE, the formula actually gives me whats in cell C15.
I am so frustrated! What am I doing wrong?