Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 5th May 2018, 12:13 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 5,315
Default Excel Help Needed

I have run in to a bit of an issue, wanting to see if i can get help here first, i have a list of race classes and beside that i have a number that i have assigned to represent the class, here is a sample.

Code:
76 35 75 36 Class 4 37 74 38 73 39 72 40 Class 3 41 71 42 70 43


I can then use this =IF(ISNUMBER(SEARCH(AW66,RacePage!$M$6)),AX66,"")
formula for todays class of race.
This formula extends the length of my class list.
AW66 represents the race class
AX66 represents the number value
RacePage!$M$6 represents today's race class and could be displayed like this on my sheet TAPETA : BM 64 HANDICAP

Now this works fine as it is searching for any part of today's race class in my list and returns the value i have assigned that class.

The problem i have is i want to swap this around, i need to be able to take a value displayed like this BM72 and search my list to find it's race class value.
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________

Last edited by Shaun : 5th May 2018 at 12:15 PM.
Reply With Quote
  #2  
Old 5th May 2018, 01:57 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 5,868
Default

Hi Shaun, I'm very confused.
Shouldn't a BM76 have a higher number?
Have you thought about using a database and just importing your data, the linked tables would give you what you want straight away.
Give me a shout if you want help with this, I'm sure I could knock something up for you quite quickly.
__________________
RaceCensus - powerful system testing software.
Now with over 304,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/09/2018
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote
  #3  
Old 5th May 2018, 02:43 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 5,315
Default

Quote:
Originally Posted by Chrome Prince
Hi Shaun, I'm very confused.
Shouldn't a BM76 have a higher number?
Have you thought about using a database and just importing your data, the linked tables would give you what you want straight away.
Give me a shout if you want help with this, I'm sure I could knock something up for you quite quickly.


The numbers don't hold any real value except to separate the class list.
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
  #4  
Old 5th May 2018, 06:27 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 5,315
Default

This code solved my issues.

=IF(AQ2="","",LOOKUP(9E+99+307,SEARCH(Data!$AW$23ata!$AW$98,A Q2),Data!$AX$23ata!$AX$98))
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 08:32 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655