I would appreciate if you get me solution to this...

"Kam" wrote:

I have got a file with 11000 invoices€¦this is just an example€¦
For bill 582792093 I have got 3 invoices on an excel it can be more too) I
want to run a kind of macro or formulae that will just give me the invoice
(2) as clearance week 4 by cancelling out 1 st invoice with the 3 rd invoice
as + & -

GB14190316-582792093 GB14190316 582792093 50
GB14204648-582792093 GB14204648 582792093 20 c
GB14486877-582792093 GB14486877 582792093 -50