R Language and Excel

[Excel777]

Hi all
I need your help i want to design an application and at the same time this application will be based on excel formulas , the reason for that dealing with large data over 250MB the excel file get freezed in calcualtion
So i thought to design my own app but iam hesitated which language which i should learn to help me in this porpuse i have read that R language is powerful language and rich with excel formulas

But i don't know if i start to learn at the end it will do my porpuse designing application based on excel calculations large data with given inputs
I need your advice

 

[AhoyNC]

R is a statistical program and has a number of packages that will link with Excel, but not sure what you mean by R being rich with excel formulas.
One thing to keep in mind is R has a steep learning curve. For statistics it is better than Excel unless you are just doing simple things like mean, median, stdev., etc.
Maybe some of these links will be of help to you.

A million ways to connect R and Excel | R-bloggers

In quantitative finance both R and Excel are the basis tools for any type of analysis. Whenever one has to use Excel in conjunction with R, there are many ways to approach the problem and many solutions. It depends on what you really want to do and the size of the dataset you’re dealing with. I […]

www.r-bloggers.com

https://www.r-project.org/conferences/DSC-2003/Proceedings/BaierNeuwirth.pdf

 

[Excel777]

Can R do multiple vlookup and count winning streak in row

 

[Excel777]

In fact i want to design software by me , but based on excel formulas which way should i walk,

 

[AhoyNC]

Yes. Take a look at the following links.

Calculating a consecutive streak in data

I’m trying to calculate the maximum winning and losing streak in a dataset (i.e. the highest number of consecutive positive or negative values). I’ve found a somewhat related question here on

stackoverflow.com