Thread: FVRatings 2012
View Single Post
  #18  
Old 13th March 2012, 09:35 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,403
Default

I made a small update to the program but won't upload a new one i will just tell you what to do.

On the "MainSheet" in cell Y31 replace the formula with this.

=IF($S$16="","",IF(ISNA(VLOOKUP(U31,$U$18:$X$21,4,FALSE)),"",VLOOKUP(U31,$U$18:$X$21,4,FALSE)))
Then click the bottom right corner of the cell and drag it down to Y38

What it does is pick up on the 4th place horse and puts in a zero just so you know the selection on the results page.
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote