Invoice and Credit Notes

[craigoutinoz]

Hi all, I am looking for a formula to help me process accounting data,
including credits canceling invoices. I need a formula that will look
through the data removing lines that are cancelled by a credit with the
same ref no except the R is replace with a C i.e. 111111 is cancelled
by 111111C1. 111111R2 is cancelled by 111111C2 and so on....

Can anyone please help?

Thanks In Advance

Craig

 

[Vasant Nanavati]

Formulas can't remove lines. You would need a macro to accomplish this.