Forum Discussion
Extract a subset of data from one sheet and copy to another sheet
I have a spreadsheet with 10 columns (first name, last name, Street, town, zip etc) and 40,000 rows of names. This is a list of registered voters. I want to search for specific names of folks Who h...
Abiola1 that doesn’t work. Or else I am not doing it correctly. I need more specific instructions. Thank you.
If VLOOKUP is unable to handle the task, INDEX /MATCH or IF should definitely get the job done...
As reiterated earlier, you may have to upload a sample file
As reiterated earlier, you may have to upload a sample file
Here is the sample file. If I want to extract the last names, and the row of data associated with these names, and copy to a new sheet, what do I do and where do I do it?
- I've seen the data and Last Name is located in column B. Just to get your question clearly, do you imply you want to copy all the Last Name from column B to another sheet? If yes, all you need to do is select all that values by executing CTRL + SHIFT + Down Arrow from cell B2. Then CTRL + C to copy. Click on the plus sheet icon to open a new sheet and CTRL + V to Paste.
In another way, if you want to combine Last Name and First Name together:
1. You can use Flash Fill, CONCATENATE, CONCAT or & to join.
Let me know if this is what you want or not... TheI want to search for a dozen names. When these dozen names are found I want to select the name and all the data in the row (last name, first name, Middle, suffix etc etc) and copy this info to a new sheet. I want to do this for the dozen names at one time not by individual name.