Horserace Form Revisited

[Saxman]

In a spreadsheet I have the following data in column A (see below).

I needed to extract the 2 digits (to the right). Claus gave me the
following formula.

=MID($A1,COLUMN(A1),1)

That worked fine, placing all digits separately in 6 columns by dragging
the formula.

However, I am only interested in the last two finishing positions. In
the first example the horse has only ran once and finished 2nd and gets
placed in column 1 after dragging. It needs to be in column 6.

Ideally, I need the penultimate (2nd last) run in one column and the
last run in another column.

=RIGHT(A1,1) will always give me the the digit to the right regardless
of its position in the column. I need a formula for the penultimate run
regardless of its position in the column.

=1*MID(A1,5,1) works fine if there are 6 digits in the column, but
returns a blank if there is not.

2
63
733
2
856
5
0
88

20_600
2785
2_0400
171934
49619
300814
610161
95145
267772
587617
26122
643/10

This would be fine if returned in two columns:-
2
63
33
2
56
5
0
88

00
85
00
34
19
14
61
45
72
17
22
10

 

[Claus Busch]

Hi John,

Am Tue, 08 Jul 2014 08:09:26 +0100 schrieb Saxman:

This would be fine if returned in two columns:-
2
63
33
2
56
5
0
88

in B1:
=IFERROR(--MID(A1,LEN(A1)-1,1),"")
in C1:
=IFERROR(--RIGHT(A1,1),"")

and copy both formulas down


Regards
Claus B.

 

[Saxman]

Hi John,

Am Tue, 08 Jul 2014 08:09:26 +0100 schrieb Saxman:



in B1:
=IFERROR(--MID(A1,LEN(A1)-1,1),"")
in C1:
=IFERROR(--RIGHT(A1,1),"")

and copy both formulas down


Regards
Claus B.

That's ideal Claus. No silly #VALUE! errors with this!

It should improve my winning chances! Thank you very much again.

Have a nice day!