"doesn't work" is not very helpful.
What result did you get? What problems did you encounter?

On Tue, 5 Aug 2008 11:21:00 -0700, LiAD
wrote:

Tried but doesn't work for some reason, sorry.

Any other ideas of how to get a find a word string and calculate the
difference between two values associated with these words?

"LiAD" wrote:

Sorry I have already asked this but the answer has been lost somewhere, or i
can't find it now.

I have a list of data which i want to match the words then calculate the
difference between the first and second of the list, then sum all the
differences, i.e

bill 10
ben 9
fred 8
june 7
bill 6
ben 5
bill 4
ben 3
june 2

so i want it to return bill 6 (10-6 + 6-4), ben 6, june 5.

Any ideas on how to match the words, search for the next match then find the
differnce and keep that going for a list of 200 items with 20 different
names, summing all the differences?