OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)
-   General Topics (http://forums.ozmium.com.au/forumdisplay.php?f=59)
-   -   Excel Help Needed (http://forums.ozmium.com.au/showthread.php?t=31843)

Shaun 5th May 2018 12:13 PM

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.

Chrome Prince 5th May 2018 01:57 PM

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.

Shaun 5th May 2018 02:43 PM

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.

Shaun 5th May 2018 06:27 PM

This code solved my issues.

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


All times are GMT +10. The time now is 12:41 AM.

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.