Hello All
On the attached worksheet the formula in col as calcs the difference in each value from the max in col aa.
The worksheets are 70 to 80k long & take a long time to calc..Is it possible to construct a macro to aid faster calculation.There are no empty rows in the data,these are for illustration only.
Many thanks for help given.
See if this solution is faster.
Make a pivot table of your data (to find the max).
After that use VLookup to find the max in the pivot table and abstract the value.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Sorry but for various reason i cant use a pivot table.Thanks for the input.Originally Posted by oeldere
I am always interested what that reason will be.
Please Login or Register to view this content.
Will you explain it to me?
Hi BigBand,
Try this:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Try this Macro
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks