'Is there any function in google sheets by which we can remove some numbers in google sheets?
Suppose there is a sheet in which there are 100 contact numbers and I want to bring the numbers in different google sheets after removing selected numbers. How can I do this??
Solution 1:[1]
So you want to replace the "the old numbers" with "New numbers for the selected contacts. Is in't it???
Then the solution is vlookup. - Remove the selected numbers - Sort it Ascending order based on the contact numbers column, so that you will get all the blank spaces bottom of the dataset. - Now you can replace/fill the blank places by using vlookup fuction.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |