Hello,
I'm looking for any help on my specific issue. I work with data sets that usually have a minimum of 130,000 rows, and find that I cannot do almost anything with these files without breaking them down into workbooks of 10,000 rows most of the time. My specs :
Processor : Intel Core i7-8565U CPU @ 1.8GHz
RAM : 16GB , 15.8 usable
System : 64 bit OS Windows 10 Pro
Excel Version : 2109 (Build 14430.20342) Microsoft 365
Workbook :
142,061 rows
21 columns
No formulas
No conditional Formatting
Just raw data
I want to check if there are any duplicate IDs so :
Add conditional formatting to only column A for duplicate values
Press the button on column A for the filter and get hung up.
It sits there spinning for minutes upon minutes. When it finally does finish, the drop down filter shows on screen for a second, then disappears. No I did not press on anything, or do anything after pressing the filter button.
Everything I read suggests I should be able to work with almost 9x this data just fine. Does anyone have any advice?
I'm looking for any help on my specific issue. I work with data sets that usually have a minimum of 130,000 rows, and find that I cannot do almost anything with these files without breaking them down into workbooks of 10,000 rows most of the time. My specs :
Processor : Intel Core i7-8565U CPU @ 1.8GHz
RAM : 16GB , 15.8 usable
System : 64 bit OS Windows 10 Pro
Excel Version : 2109 (Build 14430.20342) Microsoft 365
Workbook :
142,061 rows
21 columns
No formulas
No conditional Formatting
Just raw data
I want to check if there are any duplicate IDs so :
Add conditional formatting to only column A for duplicate values
Press the button on column A for the filter and get hung up.
It sits there spinning for minutes upon minutes. When it finally does finish, the drop down filter shows on screen for a second, then disappears. No I did not press on anything, or do anything after pressing the filter button.
Everything I read suggests I should be able to work with almost 9x this data just fine. Does anyone have any advice?