Thank you xor. I don't fully understand the criteria that decides if a cell gets taken and put into the continuous range (I have only recently learnt how to use INDEX) so I will experiment with it when I get home from work.
Thanks again for your help.
|