PDA

View Full Version : Excel programming question


Poindexter
08-21-2017, 08:08 PM
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))

barn32
08-21-2017, 11:09 PM
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

Poindexter
08-22-2017, 06:03 AM
I got it. What I was looking for this.

=(MATCH(SMALL($H$3:$H$14,1),$H$3:$H$14, 0))&"-"&=(MATCH(SMALL($H$3:$H$14,2),$H$3:$H$14, 0))&"-"&=(MATCH(SMALL($H$3:$H$14,3),$H$3:$H$14, 0))&"-"&=(MATCH(SMALL($H$3:$H$14,4),$H$3:$H$14, 0))



although in question I asked I should have used D and not H