Forum Discussion
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 ...
HansVogelaar Thanks, Hans. I appreciate the help.
When you say, "Select the list with the 350 names." Currently, that list is in a txt file.
Should it be added to the sheet I am working on? In the same tab?
When you say, "Click in the address box on the left-hand side of the formula bar."
I'm not sure what you mean.
I think I know what the formula bar is, but I can't find the address box.
This is what I am currently looking at:
Where do I find theaddress box?
Copy the list of names into a range on a worksheet - it can be the sheet with the data, or another sheet in the same workbook. That doesn't matter.