OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Need Help with Formula

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
rudagar
General User
General User


Joined: 21 Jun 2005
Posts: 21

PostPosted: Sun Jun 04, 2006 8:11 pm    Post subject: Need Help with Formula Reply with quote

I'm trying to figure out a way to set up a complicated? matching.

My tables can be seen at http://hrmleague.co.nr

What I want to do is to be able to have it so my "Top Horses" table can automatically update the horses "MARK" when it is lowered.

Basically, what it is going to do is this:

Look in Owner sheet B11:B-whatever(NAME) for where it matches the horse's name.
From there, I need to check for column H(FINISH) is 1.

That part is easy enough for me, but now:

I need to take the lowest value for the "MILE TIME"(Col L) in which these conditions are me.

I know I probably need an array returning the matches, and then use MIN to find the lowest time, but I have no idea how.


I hope this is explained clear enough.
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Mon Jun 05, 2006 10:56 pm    Post subject: Reply with quote

maybe the function SMALL( returns the k-th smallest of a sample) will help
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group