"Mike" wrote in message
...
Unfortunately the data is not in a range so I can't use any A2:A7
functions.

Where is data if not in a range?