Recent content by purvi

NarayanK991's solution is perfect!!! Narayan : Can you please provide the link to the workbook with the formulae? Thanks a ton!

@ Faseeh - in such cases either 1 and 2 or 2 and 3 should be marked as contra.....not all three.

A possible solution I have found is : I add an extra column, use ABS, then I sort on ABS and then use the following : On row 1 : If (A2= -A3, "contra",0) On the rest: If (B2 = "contra", "contra1", if (A3= - A4, "contra",0)) The above works except for cases where I have 2 debits...

hi Faseeh, tried the revised formula....it works fine except for cases where I have five lines with the same amount (2 debits and 3 credits or vice versa)...in that case instead of marking four lines as contra - it marks all five....

send it to me on exceltest4@gmail.com

@ Faseeh - tried it but the formula only marks the second entry of a pair as contra not both the lines :(

Hi...Points 2 and 3 - yes! Point 1 - no, not necessary that each amount will have an offset - the purpose of this exercise is to identify the ones that do and mark them as contra. But there could be amounts in the list that do not have an offset

@ Nayayank991 - You can only determine that by looking at the transaction amounts - if the amount is the same and one has a + and another - then the two entries are equal and opposite . To answer your second question - no the two rows need not be necessaily consequite - if that was the case...

Hi....what I need to do is find and eliminate equal and opposite transactions from the list.....so in my example above - row 1 and 2, row 4 and 6 and row 5 and 7 are equal and opposite....I need to mark these as contra and then look at only the unique entries ie the ones which do not have an...

Hi, I have an excel file containing a list of accounting entries running into thousands of lines. I need to mark as "contra" all rows where the transaction amount is debit and credit. Eg: Row Account No Desc Amount 1 1234 Rent 500 2 8910 Cash -500...