Quote:
Originally Posted by BroadwayJoe
There's one thing I see as an issue using this as a template....
Starting with V17 and down....
If you input your own data and the race has a different amount of entries than inputted here
this wont work...I believe
|
thanks for the file. I was curious how close Solver was to what I have been doing for years. Pretty, pretty, pretty close..I find a few 0f the formula constructs interesting and will try them out.
I use many formula's and macros. Given all of that I still stumble along looking for the ultimate "What IF"
Good Luck
most interesting
v17 =RANK(U17,$U$17:$U$22,0) v17 formula
t17 =IF($P17=1,$J$2,IF($P17=2,$J$3,IF($P17=3,$J$4,IF($ P17=4,$J$5,$J$6))))
thats it.