Hi all,
i have a list of people and how much they owe each other or how much they are owed:
ie
steph -10
stevie 15
tamsyn 5
nicola -7
clare -3

the question is, is there any way to get excel to create this into an easily read list which calculates a possible answer of who owes who what?

ie
i would like the output to be
steph pays stevie £10
nicola pays tamsyn £5
nicola pays stevie £2
clare pays stevie £3

any help would be massively appreciated
thanks for looking
Mat