Forum Discussion
How to find and extract
How would I find a name in a database and copy the entire multiple rows that name appears in?
It is a (csv) spreadsheet, that has list of names, amounts of DNA, and common ancestors. I need to extract specific names that are in multiple rows to place them in a new spreadsheet, to analyze the data. I am using that find function and it takes hours to extract one name to the new spreadsheet.
Have a look at the "From Text/CSV" button on the Data tab of the ribbon. It might help you filter more quickly.