I tried checking the ZIP file, but Windows says it's an invalid compressed file.
That said, you can easily 'convert' a worksheet formula into VBA by either using the Application.WorksheetFunction method, or the Application.Evaluate method.
Is there a specific reason you are looking to convert the formula into VBA, and are you seeking assistance with resolving the issue related to the compressed file?
Is there a specific reason you are looking to convert the formula into VBA, and are you seeking assistance with resolving the issue related to the compressed file?
Hello Pictwrigo, you would have seen I want to check result are in columns T:AG against combinations are in the columns B:O as this is an example there is few data.
If you multiply B:O column combinations data 375000 rows & result in column 4500 formula take lot of time to finish.
If this can convert into VBA will perform quicker that is what I believe.
Nobody can use your uploaded zip-file since it's corrupted due to Forum-Issues during that time-period.
You'd have to upload it anew.
That said:
Without knowing WHICH Formila you want to replace, and the Comparison-Logic behind it, I don't think a VBA-Code can "outrun" a Worksheet-Formula
Last edited by Zvoni; Tomorrow at 31:69 PM.
----------------------------------------------------------------------------------------
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------------------
People call me crazy because i'm jumping out of perfectly fine airplanes.
---------------------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad
Nobody can use your uploaded zip-file since it's corrupted due to Forum-Issues during that time-period.
You'd have to upload it anew.
That said:
Without knowing WHICH Formila you want to replace, and the Comparison-Logic behind it, I don't think a VBA-Code can "outrun" a Worksheet-Formula
Hello Zvoni, Please try to download this one, formula and the expected results are sown in it.
What in blazes is that Formula in Column Q supposed to do?!?!?
I'm not going to research what it does.
Describe what the Formula is doing, and maybe we can derive an algorithm for it
Last edited by Zvoni; Tomorrow at 31:69 PM.
----------------------------------------------------------------------------------------
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------------------
People call me crazy because i'm jumping out of perfectly fine airplanes.
---------------------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad
What in blazes is that Formula in Column Q supposed to do?!?!?
I'm not going to research what it does.
Describe what the Formula is doing, and maybe we can derive an algorithm for it
Zvoni, you are correct I will try to explain if not clear please ask again.
In the column B:C there is football play combinations and right side in the column T:AG there is historical football results. So basically formula is checking How much match is found with each combination?
To make it simpler live the B:C data as it is, just check 1 result is In range T6:AG6 and delete all T7:AG4505 result. You will see it will show you matching result against all combinations.
As you keep adding results will very basically formula is multi result checker.
Reply With Quote
Originally Posted by Pictwrigo
