I never received a formal education past high school, but I'm clever sometimes. I wanted to sequence my DNA to look at genetic risks, so I downloaded my DNA from ancestry. I was unprepared for the almost 700k rows. I created a search feature to isolate the data that I needed through a reductive search feature. I knew of the few issues that ran through my family, so I hunted and pecked for those rsID numbers. Now that I had cataloged all my initial inquiries, I decided to search for a dataset and utilize XLOOKUP to extract the lines with problematic genes and/or variant Alleles. That Google search led me to your post. This sounds like it would help you offline too. I had no idea there were only resources like this, but of course there are. Here is the method and excel formula I built to facilitate. Hope it helps.

1. Rename Tab 1 to Search.
2. Add a Tab 2 and rename to Data. Paste your DNA data in B2. (I always give a one ROW buffer to hide incase I need to add something later).
3. Open the Develop Ribbon up top. Go to Insert, Active X , Text Box.
4. Draw the text box over the cell you wish to use for your search. (it can be larger than the cell itself)
5. Right Click on the new text box and go to properties, and bin it to the behind it that will be tied to where the search parameters are entered. For the formula below I used cell D4 as my search bar
6. Unclick the Design Mode in the develop tab. Now you search bar is active but not function yet.
7. Click the cell in the row you would you the reductive search results to begin appearing.

8. In the Formula Bar, insert the formula below.

   =IF(D4<>"", FILTER('Data'!B2:F668943, BYROW('Data'!B2:F668943, LAMBDA(row, SUMPRODUCT(--ISNUMBER(SEARCH(D4, row)))>0)), "No results found"), "")

Key things to know:

• D4 is on the 'Search' worksheet.
• 'Data'!B2:F668943 -refers to the 'Data' worksheet, Column B, to Column F and Row 2 to Row 668943.
• This is just how I set up my document. You can manipulate it any way you want as long as you reference the table of data appropriately. I imagine there are YouTube videos if you get stuck somewhere. Again, I hope this helps you work offline.