Apr 15 2021 04:16 PM - edited Apr 15 2021 04:24 PM
I have a huge worksheet with 972K of rows. I need to create:
I have Excel for Windows as well as Mac. Also, I had converted "date" fields using Data>Text to Column.
I will appreciate the help
Apr 15 2021 11:44 PM
@Rhyme1996 Your picture isn't very helpful, as it doesn't show the date field names. But, assuming that one of them is called "Date" and has real dates in it, drag it to the Column box and group by year (if not already done automatically).
But since you mention that you are dealing with near to one million rows and have Excel for Windows at your disposal, consider connecting to the data via Power Query. Transform, clean and filter the data there and load it into the Data Model. Then, create your tables with Power Pivot.
Apr 16 2021 07:03 AM
Apr 16 2021 07:44 AM
@Rhyme1996 Not sure. You say you have a pivot table containing thousands of names and you only want to filter out a few thousands. I assume you don't want to click on every name in the Pivot Table filter box. Not even sure how many names you can have there.
Would you have a list of the names to filter out? Then you could connect to the data with Power Query (a free tool in Excel for Windows) and create a sub-set on which you can then create a pivot table. But then again, I'm not sure what you are after.
Apr 16 2021 07:50 AM