On May 29, 7:34 am, "Pegasus \(MVP\)" <I....@xxxxxx> wrote:
> "thewhizkid" <rsdive...@xxxxxx> wrote in message
> >I am familiar with MS EXcel but I dont know VBscript, so please help.
> > I have a XL sheet with data in three columns - A,B and C.
> > I want to find the biggest two out of A,B,C and then average the two.
> > How should my VBscript look like ?
> Wouldn't it be simpler to do this with a macro in Excel?
You're right, there is no stated requirement that suggests a VBS
implementation. In fact, looking at the stated problem, it would seem
to me that there isn't even a need for a VBA macro. This worksheet
formula in column D solves the problem ...
That is, unless there is something else that wasn't said in the