Too large dataset - extract data within date range

confooseddesi89 

"I've tried using a PivotTable to extract this dataset with only these dates, but even with Googling how to use them, I got stuck as I have no experience with them."

That could work if you have Power Pivot for your version of Excel. Open it, depends on your source select From Database or From Other sources and follow the wizard to import the data. After loading the data into data model you have two ways - create PivotTable from data model (as usual) or create linked-back table in the grid. For the latest on the ribbon Data->Existing Connections->Connections in this Workbook->Open (your connection)->Table.

The pro of the data model using is its performance which is extremely high. Data size on practice is limited only by your computer memory. 

confooseddesi89 

To extract the data within a certain date range in Excel, the best solution is with PQ as mentioned by Mr. Riny_van_Eekelen in his post.

However, if there is no basic knowledge of PQ, here is an alternative solution:

You can use a combination of filtering and copying the filtered data to a new sheet.

Here is how you can do it:

1. Open your Excel file and select the dataset that you want to filter (including the header row).
2. Go to the "Data" tab in the Excel ribbon and click on the "Filter" button. This will add filter dropdowns to each column header.
3. Click on the filter dropdown for the "date" column.
4. In the filter dropdown, select "Date Filters" (or a similar option depending on your Excel version) and then choose "Custom Filter."
5. In the "Custom AutoFilter" dialog box, select "is greater than or equal to" from the first dropdown and enter your desired start date (e.g., 7/17/2022) in the input box.
6. Click "OK" to apply the filter. This will show only the rows where the date is from 7/17/2022 onward.
7. Select all the visible rows (excluding the header row) by clicking on the row number on the left-hand side and dragging down to the last visible row.
8. Right-click on the selected rows and choose "Copy" or press Ctrl+C.
9. Go to a new sheet in your Excel workbook where you want to paste the filtered data.
10. Right-click on the first cell of the new sheet and choose "Paste" or press Ctrl+V. This will paste the filtered data into the new sheet.
11. If needed, you can remove the filter from the original dataset by clicking on the filter button again and selecting "Clear Filter."

Now you should have a new sheet with only the data within the specified date range. You can work with this filtered dataset in Excel before importing it into your statistical software.

I hope this helps!

confooseddesi89 Seems like you need to look into Power Query. Connect to a data source with over a million records and filter the information you need. No problem. Are you familiar with Power Query?