Have a Question?

If you have any question you can ask below or enter what you are looking for!



To highlight unique entries that doesn't get nullify

i have 3 accounting entries out of which 2 nullify eachother. How to highlight transaction that doesn't gets nullify in excel. I have a data for arround 100000.00 such entries.

  Abhishek Chauhan

Hi Abhishek,

Thanks for asking this question, any luck to share the data or Image to understand your exact requirement.


Thanks,


  Devbrat Tripathi       20 Sep 2016       0       0     


Here's the data. I just need to know o/s for tour.

TourNo. Amount
111 (224.00)
111 224.00
111 224.00
141 35.00
144 3.68
144 (3.68)
144 175.00
144 (210.00)
195 (13.89)
195 13.89
195 (15.91)
195 15.91
195 (16.90)
195 (16.90)
195 (16.90)
195 (16.90)
195 16.90
195 16.90
195 16.90
195 16.90
195 (17.50)
195 (17.50)
195 17.50
195 17.50
195 (21.20)
195 (21.20)
195 21.20
195 21.20

  Abhishek Chauhan       20 Sep 2016       0       0     


Here's the data. I just need to know o/s for tour.

TourNo. Amount
111 (224.00)
111 224.00
111 224.00
141 35.00
144 3.68
144 (3.68)
144 175.00
144 (210.00)
195 (13.89)
195 13.89
195 (15.91)
195 15.91
195 (16.90)
195 (16.90)
195 (16.90)
195 (16.90)
195 16.90
195 16.90
195 16.90
195 16.90
195 (17.50)
195 (17.50)
195 17.50
195 17.50
195 (21.20)
195 (21.20)
195 21.20
195 21.20

  Abhishek Chauhan       20 Sep 2016       0       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any