Excel programming question
I think this is probably an easy one, but my knowledge of excel is very limited.
Let's say I have a column that ranks columns the value in D3 through D16(say an oddsline) in columns F3 through F16. Cell G3-G16 would be the horses program number. This far I have gotten.
So lets say rank 1 identifies horse 3 and rank 2 identifies horse 7 and rank 3 identifies horse 6(indicated in column G). I want excel to print out in some other cell(say h20) 3-7-6 Even if I have to do so in cells h20, h21 and h22 that would work too. What do I type in excel to do this. Most question in excel I find online. This one I had some trouble with. If it matters my formula in f3 reads as follows:
=RANK(E3,$E$3:$E$16))
|