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.
Nrpandey00 You need Power query for this. So, if you are on a Windows version of Excel (2010 or later) you can use it. More about Power Query in the link below.
Thanks Ven. I used power query to load the data . Then when i tried to add/create a helper column to add formula, my excel crashes every single time.
I am using the latest version of Excel.
Is there any workaround this issue??
I am using the latest version of Excel.
Is there any workaround this issue??