Forum Discussion
EXCEL AND big data
How do i use Excel to analyse data. I have approx 3000 rows of data to be compared to approx 1.6 million row of data and extract data baaed on a certain column.
Thanks Wyn. As i mentioned it to Van, I wanted to add an extra columns to help create a unique ID. But everytime i try to put formula using a custom column, my excel crashes.
I am using the latest version of excel and my laptop is also pretty new. Is it a hardware constraints ?
I am using the latest version of excel and my laptop is also pretty new. Is it a hardware constraints ?
Hi Nrpandey00
Are you adding a column to the million row + table?
Where is your data being pulled from?
Ideally you want to be using 64 Bit Excel and have at least 8GB of RAM
If the problem continues you could load the data to the data model and add a calculated column there.