I was wondering if anyone could give me some advice with programming language i should learn for my current and future projects.
I need a program or make a program that can use excel cell data and formula’ s to a new program for faster calcuations. Preferably a bare bones spreadsheat program that can calculate large simple data sets. The problem is that excel is so slow to calculate all the data (millions of cells). Can a new program calculate faster or do i need more servers to do the calculations?
An example of data:
Data is located in multiple sheets.
From cell A1:A500 is the reference column with data sets.
From C1 To XFD500 is cells with formula’s that use cells A1:A500 as reference.
Example of a cel formula in cell c1 = A1 + A2 + A4 + A20
I copy columns with sizes A1:A500 with data to cells A1:500. So all the cells from C1:XFD500 wil have to recalculate.
Can anyone help me witch program i should learn?