You can, but the point of this is that it will automatically expand as you add data in column C.
It basically says start from C2 and then use as many rows as have data in C2:C100.
You can, but the point of this is that it will automatically expand as you add data in column C.
It basically says start from C2 and then use as many rows as have data in C2:C100.
Good luck.
can you do this instead?
![]()
=OFFSET(Sheet1!$C$2,0,0,COUNTA(Sheet1!$C$:$C$),1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks