Quote:
Originally Posted by Poindexter
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))
|
Excel questions are very difficult to answer unless you are very precise with your question.
I'm not 100% sure what you're asking, but if I guessed correctly then this is the formula. If not, try rewording.
A1 B1 C1 D1
2 3 4 234
So if A1 is 2 and B1 is 3 and C1 is 4, and you want D1 to say 234 then the formula is:
=a1&b1&c1
If you want a space between each number the formula is:
=A1&" "&B3&" "&C3