• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to run fomular faster

K

KIM Chanthan

Member
Hi Dear,

Do you have any way to make my formula run on huge data of excel smoothly?
My excel data are on 350,000 Rows 22 columns and I want to run formula in one cell then drag it down til 350,000 Rows. I spend 24 hours to wait the formula finishing. As the result it shows that only 26% completed and require me to wait more.

Your advice toward this matter is much appreciated.

Thanks,
Chanthan
 
Hi ,

Unless you explain what you want the formula to do , and post the formula that you are using at present , you may have to wait for suggestions to be tried out by you and accepted / rejected.

Giving all the details will probably result in a quicker solution.

Narayan
 
Can you post a sample file with say 20 rows,
And detail what you want to achieve as a result?
 
You must log in or register to reply here.
Back
Top