Identify last balance

[torrev07]

Hi to all,

I want to identify the last confirmed yield and operation activity from the same Order.

Some times the balance not complete the last step. So I want to know in wich step is the balance.

Order: 215775959, Last Balance = formula??

[TABLE="width: 512"]
<colgroup><col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2560;"> <col width="110" style="width: 83pt; mso-width-source: userset; mso-width-alt: 3925;"> <col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2844;"> <col width="204" style="width: 153pt; mso-width-source: userset; mso-width-alt: 7253;"> <col width="117" style="width: 88pt; mso-width-source: userset; mso-width-alt: 4152;"> <col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3527;"> <tbody>[TR]
[TD="width: 72, bgcolor: #DDDDDD"]Order[/TD]
[TD="width: 110, bgcolor: #DDDDDD"]Operation/Activity[/TD]
[TD="width: 80, bgcolor: #DDDDDD"][/TD]
[TD="width: 204, bgcolor: #DDDDDD"]
[/TD]
[TD="width: 117, bgcolor: #DDDDDD"]Operation Quantity (MEINH)[/TD]
[TD="width: 99, bgcolor: #DDDDDD"]Confirmed yield (MEINH)[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]215775959[/TD]
[TD="bgcolor: transparent"]0005[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]48[/TD]
[TD="bgcolor: transparent"]48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]215775959[/TD]
[TD="bgcolor: transparent"]0010[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]48[/TD]
[TD="bgcolor: transparent"]48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]215775959[/TD]
[TD="bgcolor: transparent"]0020[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]48[/TD]
[TD="bgcolor: transparent"]48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]215775959[/TD]
[TD="bgcolor: transparent"]0030[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]48[/TD]
[TD="bgcolor: transparent"]48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]215775959[/TD]
[TD="bgcolor: transparent"]0040[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]48[/TD]
[TD="bgcolor: transparent"]48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]215775959[/TD]
[TD="bgcolor: transparent"]0050[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]48[/TD]
[TD="bgcolor: transparent"]47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]215775959[/TD]
[TD="bgcolor: transparent"]0060[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]48[/TD]
[TD="bgcolor: transparent"]47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]215775959[/TD]
[TD="bgcolor: transparent"]0070[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]48[/TD]
[TD="bgcolor: transparent"]47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]215775959[/TD]
[TD="bgcolor: transparent"]0080[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]48[/TD]
[TD="bgcolor: transparent"]47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]215775959[/TD]
[TD="bgcolor: transparent"]0090[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]48[/TD]
[TD="bgcolor: transparent"]47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]215775959[/TD]
[TD="bgcolor: transparent"]0100[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]48[/TD]
[TD="bgcolor: transparent"]47[/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott Huish]

Which one of those columns is the balance? And what result do you expect?

If it's column F:
=LOOKUP(2,1/(A2:A12=215775959),F2:F12)

If it's column E:
=LOOKUP(2,1/(A2:A12=215775959),E2:E12)

Is this what you want?