Guest User

Untitled

a guest
Jul 16th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. function DupeDestroyX(range,a,b,index) {
  2. var j = index-1 || 0;
  3. for(var i=0;i<(range.length-1);i++){ //loop over all entries
  4. try {
  5. if(range[i][j]==a && range[i+1][j]==a) { // if current entry is a and next entry is also a
  6. range.splice(i,1); // delete current entry
  7. if (range[i+1][j]==a) {i--} //If next entry is also a (after deleting),loop repeat this iteration
  8. }
  9. if(range[i][j]==b && range[i+1][j]==b) {
  10. range.splice(i+1,1); //delete next entry
  11. if (range[i+1][j]==b) {i--}
  12. }
  13. }
  14. catch(e) {continue;}
  15. }
  16. return range;
  17. }
  18.  
  19. =DupeDestroyX(A1:C,"a","b")
Add Comment
Please, Sign In to add comment