Quote:
Originally Posted by formula_2002
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.
|
MJ did add rMLO to this sheet ....
Along with this and V column I mentioned looks like he did stuff outside of this
sheet making it not quite a template but its seems doable to fix ..
Just need time and quiet thoughts to write all the formulas
I plan on adding something like 20 factors to make a template that I can go
forward with...
Mike