last month

[mistersteve]

I have a row of months as below

Jan Qty

Jan £

Feb Qty

Feb £

Mar Qty

Mar £

Apr Qty

Apr £

May Qty

May £

Jun Qty

Jun £

Jul Qty

Jul £

25

68.75

25

71

<colgroup><col width="61" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;"> <col width="61" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" span="11"> <col width="61" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" span="2"> <tbody> </tbody>

this continues onto Dec.

I am looking for a formula that will tell me the latest month a product has been inputted and the qty

Thanks

 

[Aladin Akyurek]

1. Last month

=INDEX(A1:N1,MATCH(9.99999999999999E+307,A2:N2)-1)

2. Last month qty

=INDEX(A2:N2,MATCH(9.99999999999999E+307,A2:N2)-1)

 

[FDibbins]

Similar option...

A​

B​

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

M​

N​

1​

Jan Qty​

Jan £​

Feb Qty​

Feb £​

Mar Qty

Mar £​

Apr Qty​

Apr £​

May Qty​

May £​

Jun Qty​

Jun £​

Jul Qty​

Jul £​

2​

25​

68.75​

25​

71​

3​

4​

Jul Qty

5​

25​

A4=INDEX($A$1:$N$1,MATCH(0,A2:N2,-1)-1)
A5=INDEX($A$2:$N$2,MATCH(0,A2:N2,-1)-1)