LinkBack URL
About LinkBacks
bshbros, it seems that you want all duplicates deleting is that correct? or do you only want a row deleting that has a positive value in column D and then a negative value in column D for the same person?
bshbros, it seems that you want all duplicates deleting is that correct? or do you only want a row deleting that has a positive value in column D and then a negative value in column D for the same person?
Not all forums are the same - seek and you shall find
Hi Simon,
If A,B,C and D are the same and the values in column E sum to 0, then both rows need to be deleted. Once that occurs, the remaining negative amounts would need to be deleted and finally, for cleanliness only, all rows with 0 on column E need to be deleted. I suppose if the rows with 0 in column E are deleted first there will be fewer rows to check.
Thank you for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks