Many times we need to find duplicate values and highlight them with the same color in the active tab selection.
This can not be done by any future of google sheet.
This tool will help you to find duplicate values highlighted with the same Color within the active tab selection.
CLICK HERE to Install the addon.
How to Open Functionality:
- First of all open the Google sheet then go to Extension > Sutra Tools > Highlight Duplicate > Values In Selection like the below screenshot:
- After clicking on this, it shows highlighted values as yellow color and the count of highlighted values in the window like the below screenshot.
Use of Functionality:
- First of all this functionality works only with the current tab active selection.
- It will use Highlight Duplicate Values in the current tab active Selection.
Note: It will highlight with Yellow color.