How could i get the following excel formula to work using VBA:
{=LARGE(ABS($D$18:$D$23),G23)}
In this example i have my data in cells D18:D23 and in cells G18:G23 numbers 1 to 5, so with the formula above in H18 i can drag it down to H23 to get the 1st - 5th largest absolute values.
Using VBA how could i achieve the same results?
{=LARGE(ABS($D$18:$D$23),G23)}
In this example i have my data in cells D18:D23 and in cells G18:G23 numbers 1 to 5, so with the formula above in H18 i can drag it down to H23 to get the 1st - 5th largest absolute values.
Using VBA how could i achieve the same results?