Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board

Go Back   Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board > Off Topic > Off Topic - Computers


Reply
 
Thread Tools Rate Thread
Old 08-21-2017, 07:08 PM   #1
Poindexter
Registered User
 
Join Date: Mar 2007
Posts: 1,964
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))
Poindexter is offline   Reply With Quote Reply
Old 08-21-2017, 10:09 PM   #2
barn32
tmrpots
 
barn32's Avatar
 
Join Date: Jun 2008
Posts: 2,285
Quote:
Originally Posted by Poindexter View Post
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
barn32 is offline   Reply With Quote Reply
Old 08-22-2017, 05:03 AM   #3
Poindexter
Registered User
 
Join Date: Mar 2007
Posts: 1,964
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
Poindexter is offline   Reply With Quote Reply
Reply




Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

» Advertisement
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 11:10 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright 1999 - 2023 -- PaceAdvantage.Com -- All Rights Reserved
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program
designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.