[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
jpw8174
Newbie

Joined: 02 Mar 2009
Posts: 2

 Posted: Mon Mar 02, 2009 3:30 pm    Post subject: Conditional formating with indexing C7;AND(B7>D7;AND(B7>E7;AND(B7>F7)))) = True I7 =IF(C7>B7;AND(C7>D7;AND(C7>E7;AND(C7>F7)))) = false J7 =IF(D7>B7;AND(D7>C7;AND(D7>E7;AND(D7>F7)))) = false K7 =IF(E7>F7;AND(E7>D7;AND(E7>C7;AND(E7>B7)))) = false L7 =IF(F7>E7;AND(F7>D7;AND(F7>C7;AND(F7>B7)))) = false the result is true ot false, I think i got the compare right but it still isn't close to what I am after. this might not even help. I then figured i would have to have it pick the one that is true and then get the name from the range above which then would be H6 to L6 =INDEX(H6:L6;MATCH("true";H7:L7)) My result is the name in L6 when H7 is tcorrect result the name i want is H6
keme
Moderator

Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

 Posted: Mon Mar 02, 2009 11:00 pm    Post subject: You are comparing a logical value to a text string. Try typing TRUE without the quotes. I haven't figured out the logic of your formulas, but from your description of the task, I suspect you could use the SMALL(), LARGE(), and/or RANK() functions.
jpw8174
Newbie

Joined: 02 Mar 2009
Posts: 2

 Posted: Tue Mar 03, 2009 7:14 am    Post subject: Thank you TRUE with out the quotes became a 1 once io hit enter and now it works except for 2 instances I have 2 people that are both equal with the highest stat so they return a flase in my greater then formula. those 2 stats give the name of L6 how do I make it return a given value of "no clear leader" I there a formula that would compare say B7 to F7 and return the highest figure and cross reference the name from the index for which on has the highest. I am close to it but to get that info I needed to create 6 different formulas where I was hoping for 1 the index is B1 to F1 I have 25 stats to track with currently 5 people but there will be more. I like working with a range of cells rather then being very exact to name each cell (like with =SUM(A1:A99) if I ad a cell in the middle the range expands and counts the new cell automaticly. I have this working with sveral different formulas in my file.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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