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.

 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 5th May 2018, 12:13 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
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
 


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 12:54 AM.


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