Is there any way I can string together offsets?
For example, starting at A1, I want to go down 4 (to Ben Johnson), none across, then return 5 down and 10 across
so that would be
=offset(A1,4,0,5,10)
but what if I wanted to return details for rows 14 to 15 and 18 to 21 too? is there some way to string them all together?
I'm really new to this so excuse my ignorance & many thank!
Claire
Data.jpg
Bookmarks