Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 'Attempt 1
- =(INDEX('Ontario - Monthly'!3:3,MATCH(9^99,'Ontario - Monthly'!3:3)))
- 'Attempt 2
- =LOOKUP(2,1/(('Ontario - Monthly'!AO3:NH3<>"")),'Ontario -Monthly'!AN3:NH3)
- 'Attempt 3
- =OFFSET('Ontario - Monthly'!AN3,'Ontario - Monthly'!AN3:XFD3-3,1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement