Hi All
How can you write formula to exclude a race where 2 runners are joint price
Thanks Regards Shaune
Double Selection
Moderator: 2020vision
3 posts
• Page 1 of 1
Double Selection
by horsesystemagic » Mon Sep 06, 2010 9:30 pm
- horsesystemagic
- Posts: 15
- Joined: Fri Jul 23, 2010 12:48 pm
by osknows » Mon Sep 06, 2010 10:06 pm
This ARRAY formula will work out if any prices match in the back column F
=IF(SUM(IF(FREQUENCY(F5:F55,F5:F55)>0,1))-COUNT(F5:F55)=0,"All Unique","At least one match" )
As its an array formula enter the formula using CTRL+SHIFT+ENTER
=IF(SUM(IF(FREQUENCY(F5:F55,F5:F55)>0,1))-COUNT(F5:F55)=0,"All Unique","At least one match" )
As its an array formula enter the formula using CTRL+SHIFT+ENTER
-
osknows - Posts: 946
- Joined: Wed Jul 29, 2009 12:01 am
by osknows » Tue Sep 07, 2010 8:46 am
In response to your PM the equation to test for a joint favorite is
=IF(COUNTIF(F5:F55,MIN(F5:F55))>1,"Joint Favorite","No Joint Favorite")
=IF(COUNTIF(F5:F55,MIN(F5:F55))>1,"Joint Favorite","No Joint Favorite")
-
osknows - Posts: 946
- Joined: Wed Jul 29, 2009 12:01 am
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: Bing [Bot] and 32 guests