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?
