User Profile
TimMarston
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Find and Replace Multiple Data Points (Or aDifferent Solution?)
Hi I am using Microsoft Excel for Mac and am stumped with a problem. I have a sheet with one column that has 340,000 rows of data. I have a list of 350 names that I want to search the first column for. But these names are only a part of the data in the column. For example, if this was a row in the column: https://techcommunity.microsoft.com/t5/forums/postpage/board-id/ExcelGeneral My list would only contain this: techcommunity.microsoft.com I am trying to delete any row in the column containing a name from the list of 350 names. If I could highlight or ID the rows somehow, that could be workable as well, but deletion would be ideal. Apart from doing this manually with find and replace, I have no idea how to do it. My Excel skills are very limited. I do no know if what I am asking is hard or easy, but it feels hard to me! Any help would be much appreciated. Thanks Tim996Views0likes6Comments
Groups
Recent Blog Articles
No content to show