OZmium Sports Betting and Horse Racing Forums

#18

28th May 2011, 04:50 PM

Shaun

Member

Join Date: Jan 1970

Location: Western Australia

Posts: 3,457

My excel formulas can be a bit different as i am not the best at combining them but this should work.

format the cell to text so if A1 has 1-9
A2=TRIM(CLEAN(LEFT(A1,FIND("-",A1)-1)))
A3=IF(A2+0=1,"Winner","")
replace the winner with what ever you want as a flag.

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

All times are GMT +10. The time now is 11:00 AM.

	To advertise on these forums, e-mail us.