The Gold-Bug

It’s the middle of the night in the middle of nowhere. So this is briefer than I’d otherwise wish.

Thank you Mr Grandison, Phil and Hunters and Scoobies all together for all that you’ve posted. The right thing will be done now, I'm certain.

Phil, a great idea for the 30th. I hope I’ll be there in some (virtual) shape or form. :)

I miss you, all of you. But it’s right and I’m happy that I am where I am. This distance is going to help me start afresh.

It remains for me, Sonia Moray, to release William Moray’s code to you all.

www.snipurl.com/reconcile

Good luck! Or should I say ‘allons-y’!

Sonia Moray xx

Hoorah!

Sonia, thanks so much! I do hope we get to see you again in better circumstances!

Hi Sonia - good to hear that you are well and in a place that is right for you at the moment. If you were able to make some kind of appearance on the 30th that would be lovely. Thank you for giving us the code in time to spend all Easter weekend on it !!

Excellent news! Best wishes Sonia

Thank you Sonia.
Wow just looking at it, it might take a while to decode!
Glad you are safe and sound somewhere.

Arrrghh. The site is blocked by my work place as ever. Thank goodness I have the bank holiday weekend ahead of me and with the dreadful weather I will definitely now have something to occupy my time!

There should be no need to do this labouriously by hand.. a VLOOKUP and the key Karen/Linda/Steve made - the one Bonnie sent you, David - should do the trick.

What on earth is a VLOOKUP?

vlookup is the greatest function in excel ever.

it looks up one value in a range and returns the value from that column (or adjacent column in the range). Perfect for finding a unique data item from one list in another list.

Yep, sorry, didn't have time for more: I will see I can excel-wrangle...

Now you tell me. I've just solved the whole thing by hand. It took me about 2 hours. I'm posting it on a new forum thread, in case others don't want to see if yet.

I think a few letters in the sheet were a bit out, so it's only my interpretation.

Oh No! Ah well, I can at least vindaicate your work hey? I wonder if

tbgfefqptjucpy29543119

'safe deposit box 29543119'

will lead us anywhere?

Karen, you have done it all! Wow, hats off. I haven't even looked at it. But it's home time soon, so this is what I will be doing for the rest of my evening!

I had the day off so thought I'd take advantage to get ahead, as I usually trail behind the rest of you.

However again, I'm only the administrator really as it was many others who did the real work.

I'm not sure it's entirely correct,so I'd be interested to hear from others when they've had chance to have a look. A trip out may be called for!

Karen, you were really quick. I also spent all afternoon doing it by hand but you beat me (I had fun doing it though:)

tbgfefqptjucpy29543119 (the unsnipped url)

becomes

'safe deposit box 1843 2008'

when shifted one letter and numeral.

I've lost the plot due to chocolate poisoning over Easter - where did tbgfefqptjucpy29543119 come from?

it is the URL that comes up when you click on the link Sonia provided for the code!

Ah - thanks Bonnie. I missed that.