Removing duplicate values from Google Sheets
Budget: $8 – $15 AUD
Hi there I have 4 tabs on a spreadsheet (two separate formulas) I need some scripting or more complex formulas than I am capable of created for.
Issue 1.
Need to check one column of data for matches with another column on another tab, and if there is a match it will delete both values and move the unique results to a 3rd tab.
Issue 2.
Need to compare two columns of data and if they are a match remove the duplicate value from one of the pages.
Here is a video showing what I need.
http://somup.com/cr6rYN3yVl
Here is a link to a google sheet for you to work on if you want to take a look.
https://docs.google.com/spreadsheets/d/19F_-fEMfJ4WgUYMJiJIeF2-ifnEi0EwJbzx_7rJw_LE/edit?usp=sharing
Issue 1.
Need to check one column of data for matches with another column on another tab, and if there is a match it will delete both values and move the unique results to a 3rd tab.
Issue 2.
Need to compare two columns of data and if they are a match remove the duplicate value from one of the pages.
Here is a video showing what I need.
http://somup.com/cr6rYN3yVl
Here is a link to a google sheet for you to work on if you want to take a look.
https://docs.google.com/spreadsheets/d/19F_-fEMfJ4WgUYMJiJIeF2-ifnEi0EwJbzx_7rJw_LE/edit?usp=sharing