Hi

It looks to me that all your duplicated amounts are Cancelled - which
would be correct, with contra values being written against the first sum
of money.

If you apply an Autofilter, then filter on Comments for Cancelled.

Alternatively, you can mark the whole block of your dataSort Column
CAscending and all of the Cancelled transactions will fall to the
bottom of the list.
--
Regards
Roger Govier

Radhakant Panigrahi wrote:
Hi,
can anybody help in the below query
i have the below data with me
RECEIPT_NUMBER TRX_NUMBER PAYMENT_AMOUNT Comments
9907893007 7000604737 151.06 Cancelled
9907893007 7000604737 (151.06) Cancelled
9907893007 7000604737 151.51 Cancelled
9907893007 7000604737 (151.51) Cancelled
9907893007 7000604737 155.25 Bill
9910789407 7000857919 4,239.33 Cancelled
9910789407 7000857919 (4,239.33) Cancelled
9910789407 7000857919 4,239.33 Bill
9910699310 7100467576 88.37 Cancelled
9910699310 7100467576 (88.37) Cancelled
9910699310 7100467576 88.37 Bill

in the above details the some transactions are coming repetitively and
having +ve and -ve with same amounts cancelling each other and i need
manually segregate them...and i have to do it for almost 20000 lines with
1000 transactions having the duplicacy problem. Is there any way or formula
that would help me... i have tried the Vlook up formula but in vein.