Is there a way of removing data in bulk rather than individually?
for example, the below info is in column A in amongst 750 rows of data. Instead of deleting the results 1 by 1 can this be done in bulk ie copy all this info and tell the sheets to delete? Or is there any tools that can do this?
oboylerealestate
johnsonteamworks
coloradojoe
fixercreative
raynorrealty719
casamundiliving
sellstatesummitrealty
makespringshome
riversiderecolorado
vanessabivens.
sorry, im editing this due to incorrect suggestion.
method:
Sort the column from A-Z
Now delete the rows that you don't want
Last edited by janmorris; 07-27-2021 at 03:10 PM. Reason: correcting my suggestion
Put the data in the data tab. Put the names you want to include - exclude in the tab 'list' Use this formula =if(iserror(VLOOKUP(left(A2,FIND(".",A2)-1),List!$A$1:$A$10 ,1,0)),False,True) and then filter to True or false.
https://docs.google.com/spreadsheets...it?usp=sharing
Last edited by Vraag en antwoord; 07-27-2021 at 03:34 PM.
Messages have been translated from Dutch to English by means of google translate.
As you have some help here, and because you are still new, I have closed your earlier thread, however please take note of the rule on thread duplication.
Administrative Note:
You are allowed only ONE thread per issue here.
Please see Forum Rule #5 about thread duplication.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Ok thanks boss
Last edited by AliGW; 07-27-2021 at 04:45 PM. Reason: Stop quoting unnecessarily, please.
Originally Posted by Vraag en antwoord
Ok thanks for you reply but once I'm on the Data tab where do i go ? I have also requested access to your google sheet link!
I almost never work with google sheets. So place your own document. Can you follow the formula and the explanation?
No! I'm not sure where to put the formula
Please have a look at my sheet
https://docs.google.com/spreadsheets...it?usp=sharing
I have added a few domains under where it says delete in bulk. There are around 200 that I'd like to delete in bulk.
I think you put very little effort into it. The file is different from the question. Everything you need is in #3 And you can even leave out a lot.
Ok so I put the data in Column A
Then I create a new tab at the bottom called List and past the names that I want to remove
Where do i then paste the formula? =if(iserror(VLOOKUP(left(A2,FIND(".",A2)-1),List!$A$1:$A$10 ,1,0)),False,True)
And do I need to mark the list of names that I want to remove as False ?
I think the functions used are quite easy to find from google. It's not all that complicated.
The names that you have added to the List tab are still in the main section ( Sheet 1). I don't want to see them in sheet 1 so what is the formula to either change them from False to True so I can filter them and delete or remove them completely using 1 formula?
i have changed the formula to the following:
now, in column B you get a filtered list, which you can then copy and paste the values to anywhere you like.
Please Login or Register to view this content.
That is great thank you. I now see how this is working. Paste the list I don't want in the list tabs and then on the main tab in Column B I will be left with the good data.i have changed the formula to the following:
now, in column B you get a filtered list, which you can then copy and paste the values to anywhere you like.Please Login or Register to view this content.
Thank you
Is there a way of bulk filtering keywords and then highlighting them with a certain color?i have changed the formula to the following:
now, in column B you get a filtered list, which you can then copy and paste the values to anywhere you like.Please Login or Register to view this content.
Administrative Note:
Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!
For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.
There are two possible solutions, solution 1 only works when the data is on same sheet, solution 2 allows for data on a separate sheet.
SOLUTION 1 (make many changes to existing spreadsheet)
put full list in column A
put the list you want removed in column B of the same sheet
in cell C1 put this formula:
select column A, then go to Format> Conditional FormattingPlease Login or Register to view this content.
set Format rules, Format cells if... "Custom formula is"
enter this formula:
now in column A the cells that will be removed will be highlightedPlease Login or Register to view this content.
in column B will be the cells you want removed
in column C will be the filtered list, the coloured items in column A will be removed
SOLUTION 2 (easy, only need to add conditional formatting to the existing spreadsheet)
select column A, then go to Format> Conditional Formatting
set Format rules, Format cells if... "Custom formula is"
enter this formula:
now the cells to be removed will be highlighted in column APlease Login or Register to view this content.
the filtered list will be in column B
and on the List sheet will be the items you want removed
Last edited by janmorris; 07-28-2021 at 09:34 PM. Reason: add more solutions
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks