I need a formula to highlight each set of duplicate numbers that equal zero, the attached file has duplicate numbers under neath each over next to a positive and minus qty. i could just delete them manually but i wondered if there was a formula to make it easier.
Last edited by Jonmc89; 07-21-2017 at 08:26 AM. Reason: title
This in C2 copied down will identify those to delete:
=IF(SUMIF(A:A,A2,B:B),"","Delete")
Filter on "Delete", select range and then "delete row"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks