Forum Discussion

migoblu's avatar
migoblu
Copper Contributor
May 20, 2021

How to find and extract

How would I find a name in a database and copy the entire multiple rows that name appears in?
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
May 20, 2021
What kind of database?
  • migoblu's avatar
    migoblu
    Copper Contributor
    May 20, 2021
    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.
    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      May 20, 2021
      Have a look at the "From Text/CSV" button on the Data tab of the ribbon. It might help you filter more quickly.
    • mathetes's avatar
      mathetes
      Silver Contributor
      May 20, 2021

      migoblu 

       

      Are you familiar with the FILTER function? From your description it would appear to be what you're looking for. It's a new function that requires the newest versions of Excel. Here's a video that explains it

      https://www.youtube.com/watch?v=9I9DtFOVPIg

       

Resources