OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)
-   Horse Racing (http://forums.ozmium.com.au/forumdisplay.php?f=5)
-   -   Help needed with Excel (http://forums.ozmium.com.au/showthread.php?t=2378)

enjay 17th March 2003 04:17 PM

Any excel gurus out there that can give me a hand. I am wondering if it is possible to search for multiple horses in one hit...I can save all the days races to excel and what I want to do is to search for multiple horses that may be running that day. The horses I would be searching for would be in another text or data file or whatever would be needed.
I guess I want to be able to run my own 'Black Book Horses' I know how to do single searches but this one is beyond my capabilities.

Enjay.

woof43 17th March 2003 05:23 PM

Hi you might like to try looking under Format,then Conditional Formating.If you would like to highlight Horses say in a colour that meet your requirements.they would then appear readily when you look at the data.

becareful 17th March 2003 07:56 PM

Enjay,

You can use the Vlookup function to solve this problem - it is a bit tricky to explain on the forum so if you want to send me an email at the tipping comp email address I can email you a sample spreadsheet to show you how it works.

Regards,
Becareful


All times are GMT +10. The time now is 01:31 PM.

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