Cheers Pete,

Actually, just after posting my last message I had another go and tried
using IF. I came up with the following all on my little lonesome (I just
wanted to let you know that all your teaching is not in vain! :)):

=IF('4th November 2005'!B16="","nothing here dude",
IF(B16<'4th November 2005'!B16,"UP (+"&TEXT(IF('4th November
2005'!B16="Not in top 100","101",'4th November 2005'!B16)-IF(B16="Not
in top 100","101",B16),"00")&")",
IF(B16='4th November 2005'!B16,"Same",
IF(B16'4th November 2005'!B16,"DOWN (-"&TEXT(IF(B16="Not in top
100","101",B16)-IF('4th November 2005'!B16="Not in top 100","101",'4th
November 2005'!B16),"00")&")" ))))

Let me know if you can spot any errors or if your solution provides a
neater alterative - I just was quite pleased to have managed to figure
something out :)

Regarding the images, is the only option to use wingdings, as I really
wanted to be able to use a green arrow for up and a red arrow for down
(unless you can colour wingdings?)

Cheers
Kessa


--
kessa
------------------------------------------------------------------------
kessa's Profile: http://www.excelforum.com/member.php...o&userid=32080
View this thread: http://www.excelforum.com/showthread...hreadid=518338