I'm using regular Excel formula in the cells (not scripting, mainly
because I don't know how). I have a problem with trying to combine
offset() and small()

my actual code is:

=OFFSET(small(E4:E18,1),0,-2)

and it obviously doesn't work.

Is there any way to use those two features together?

If it helps I'm trying to make a gradebook capable of weighting
categories (e.g. 50% of avg for quiz, etc.) and dropping lowest
quizzes. I have all the code working except this one combination of
finding the lowest grade using small() and returning its corresponding
number using offset().

Thanks in advance for any help.

Marcas Burnett
marcas91[at]gmail[dot]com
-----------------------------------------------------------------------------------------------------------------------------------------------

Hi!

The first argument in Offset must be a cell address. See if this does
what
you want:

=OFFSET(E4,MATCH(SMALL(E4:E18,1),E4:E18,0)-1,-2)

Biff
-----------------------------------------------------------------------------------------------------------------------------------------------

The only thing is: will the match function work if two grades can be
the same? (if you can make 2 95's then will the match function work?)

See you original post!

Biff

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm using regular Excel formula in the cells (not scripting, mainly
> because I don't know how). I have a problem with trying to combine
> offset() and small()
>
> my actual code is:
>
> =OFFSET(small(E4:E18,1),0,-2)
>
> and it obviously doesn't work.
>
> Is there any way to use those two features together?
>
> If it helps I'm trying to make a gradebook capable of weighting
> categories (e.g. 50% of avg for quiz, etc.) and dropping lowest
> quizzes. I have all the code working except this one combination of
> finding the lowest grade using small() and returning its corresponding
> number using offset().
>
> Thanks in advance for any help.
>
> Marcas Burnett
> marcas91[at]gmail[dot]com
> -----------------------------------------------------------------------------------------------------------------------------------------------
>
> Hi!
>
> The first argument in Offset must be a cell address. See if this does
> what
> you want:
>
> =OFFSET(E4,MATCH(SMALL(E4:E18,1),E4:E18,0)-1,-2)
>
> Biff
> -----------------------------------------------------------------------------------------------------------------------------------------------
>
> The only thing is: will the match function work if two grades can be
> the same? (if you can make 2 95's then will the match function work?)
>