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...
Hello,
You can use VLOOKUP to do that... You can as well upload a sample data
You can use VLOOKUP to do that... You can as well upload a sample data
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 fileHere 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... The