Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =UNIQUE('Sheet Name'!A$2:A)
- =FILTER('Sheet Name'!A$2:A, NOT(ISBLANK('Sheet Name'!A$2:A)))
- =INDIRECT("Sheet1!A"&(ROW(A2)&0)-10)
- =FILTER(Sheet1!A1:A, MOD(ROW(A1:A), 10)=0)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement