Compare two numbers separated by a dash

[Brutality]

Not sure if this can be done without separating the numbers out into different columns, but here is the scenario; I have a spreadsheet containing match scores. Scores have been entered in the format 10-8 (in a single cell) and I need to determine the winner I.E. which number is bigger, the left or right. Any ideas? I've messed with mid() and value(left()) but cant get the result I am after. All help appreciated.

TIA
Mark

 

[T. Valko]

Not sure if this can be done without separating the numbers out into different columns, but here is the scenario; I have a spreadsheet containing match scores. Scores have been entered in the format 10-8 (in a single cell) and I need to determine the winner I.E. which number is bigger, the left or right. Any ideas? I've messed with mid() and value(left()) but cant get the result I am after. All help appreciated.

TIA
Mark

Are ties possible?

=IF(--LEFT(A2,FIND("-",A2)-1)>-MID(A2,FIND("-",A2),5),"Left","Right")

 

[Brutality]

Ooops, yes they are, my bad sorry. The idea here is to give the winner 2 points, the loser 0, and 1 for a tie. So far your code works well and I will attempt to modify the rest myself. Thanks for the swift reply and working formula Mr Valko!

 

[bebo021999]

If A1 contain match scores:

=IF(--LEFT(SUBSTITUTE(A1,"-",REPT(" ",2)),2)>--RIGHT(SUBSTITUTE(A1,"-",REPT(" ",2)),2),"Win-Loss",IF(--LEFT(SUBSTITUTE(A1,"-",REPT(" ",2)),2)<--RIGHT(SUBSTITUTE(A1,"-",REPT(" ",2)),2),"Loss-Win","Balance"))

 

[T. Valko]

Ooops, yes they are, my bad sorry. The idea here is to give the winner 2 points, the loser 0, and 1 for a tie. So far your code works well and I will attempt to modify the rest myself. Thanks for the swift reply and working formula Mr Valko!

You might be better off separating the numbers to individual cells.

It ought to be pretty easy using Data>Text to Columns>Delimited by the dash.

 

[Brutality]

I've looked at that option T Valko and had it working but it requires a lot of "re-arranging of data" in the current provided spreadsheet and was trying to avoid such an approach.

Bebo, great, perfect, thanks!

I appreciate both of your solutions. Cheers.

 

[mikerickson]

If the score is in A1, the named value =SIGN(EVALUATE(A1))+1 will return the 2,1,0 score of the left side team.