MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Question concerning calcs in VBA

  Asked By: Matilda    Date: Oct 29    Category: MS Office    Views: 560

I am trying to calculate a top twenty list for work. Any ranking below
20 (in a list of about 100), the macro should take the adjacent cell
and sum it against all other rankings below 20. I am trying to use a
loop program but I am having difficulties figuring it out.



2 Answers Found

Answer #1    Answered By: Jean Bell     Answered On: Oct 29

Why don't you post what you have for code so far. That will make it
easier for us to conceptualize what you are attempting to do.

Answer #2    Answered By: Dominic Murphy     Answered On: Oct 29

Try getting MOREFUNC.XLL from http://xcell05.free.fr

It adds a function called
MMIN that returns the N lowest numbers of a range or an array.

Then you can use SUM(MMIN(yourdata))

Is that what you are looking for?

Didn't find what you were looking for? Find more on Question concerning calcs in VBA Or get search suggestion and latest updates.