Hi, Using the public forums , I managed to partly build up a file that helps to split costs among friends. But I will need further help completing this. Please refer attached.

Hi Josef,

Am Thu, 17 Dec 2015 04:32:52 +0000 schrieb Excel Dumbo:

+-------------------------------------------------------------------+
|Filename: Friends Expenses Split.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=1023|
+-------------------------------------------------------------------+

in I5:
=IF(VLOOKUP($G5,$B$4:$E$11,4,0)<0,0,MIN(VLOOKUP($G 5,$B$4:$E$11,4,0)-SUM($H5:H5),ABS(VLOOKUP(I$3,$B$4:$E$11,4,0))-SUM(I$4:I4)))
and copy to the right and down.

Or look he
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for your workbook (Friends Expenses Split)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Thank you very much claus. Worked perfect