guatelize
06-13-2012, 05:59 AM
Hello
I have a large file with dates and numbers, I found a formula to extract the closest value and return the adjacent values. But when I injected the formula into my file, it took 1 hour to have a result :whistle: :doh: .
:help Is it possible to speed it up the calculation with a macro or to replace the formula by a macro?
(File included)
Thanks for your help
I have a large file with dates and numbers, I found a formula to extract the closest value and return the adjacent values. But when I injected the formula into my file, it took 1 hour to have a result :whistle: :doh: .
:help Is it possible to speed it up the calculation with a macro or to replace the formula by a macro?
(File included)
Thanks for your help