|
|
To advertise on these forums, e-mail us. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
some excel help please
Could someone please help?
I was trying to download some form from the ozeform horse search database and have encountered a few problems that go beyond my excel abilities. The major problem is the finishing position and field numbers. For example 1/12 will come out as 1 December. I know that the columns need to be formatted but I cant seem to do it correctly. I would also like to split the two figures into seperate cells. Also with the beaten margin figure, if the horse has won the margin to the second horse comes up and as I am experimenting with the beaten margins I would like excel to turn the margin to zero if the horse has finished first. Thanking you in advance. my email address is sonnyboy64 at optusnet dot com dot au Happy new year to everyone on the forum and please drive safely tonite. Last edited by DR RON : 31st December 2004 at 07:31 PM. |
#2
|
|||
|
|||
Hi Ron,
I can probably help you....I think. If you want, send me an excel example and I'll give it a shot. racestats at hotmail dot com. |
#3
|
|||
|
|||
I sent you an E-mail Dr Ron have done lots of work with the Oze Form site as well as cyberhorse site regarding this issue
|
#4
|
|||
|
|||
Thanks guys, emails have just been sent.
|
#5
|
|||
|
|||
DR RON,
I've sent you a workaround for this problem just now with an example. Cheers. |
#6
|
|||
|
|||
Mind sending that to met Chrome would like to take a look
shaun2166@hotmail.com |
#7
|
|||
|
|||
Copy sent to you Shaun.
Cheers. |
#8
|
|||
|
|||
May i also get a copy Chrome
kewldude28 at hot mail dot com Thanks in advance |
#9
|
|||
|
|||
Thanks chrome....i am new at excel and wanted see if what i was doing to extract information was correct....and it was according to your file....i also use this formula to extract information from cyber horse form
=TRIM(MID(A$2,FIND("&",SUBSTITUTE(A$2,",","&",B2))+1,FIND(",",REPLACE(A$2,1,FIND("&",SUBSTITUTE(A$2,",","&",B2)),""))-1)) where B2 has the amount of commas that you want to skip to and A2 contains the form line |
#10
|
|||
|
|||
Wow Shaun, you're obviously far more advanced than me at this.
My codes are very basic and you have got a much better grasp at getting the info "parsed". Well done and thanks for the code. I'll email you a workaround for Cyberhorse as well that may not require code. |
Thread Tools | Search this Thread |
Display Modes | |
|
|