find the next data

[amirsaeed]

assume i have a table like bellow
[TABLE="width: 500"]
<tbody>[TR]
[TD]456[/TD]
[TD]2486[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]789[/TD]
[TD]6842[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]8624[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]4862[/TD]
[TD]=[/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]9713[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]7139[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]789[/TD]
[TD]1397[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]3971[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]6985 [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

i want excel to
for example i'm in column C4
i want to find next 123 below A4(which is 123) then add its B column to B4(which is 4862)
in this example the cell would be A6(which is the next 123 in column A below A4)

 

[Aladin Akyurek]

How is different from your post in: http://www.mrexcel.com/forum/excel-questions/910752-two-statement-time.html#post4379640?

 

[amirsaeed]

How is different from your post in: http://www.mrexcel.com/forum/excel-questions/910752-two-statement-time.html#post4379640?

i want excel that every time i write 123 in column A, excel finds the last 123 from column A and then add their B column with each other
for example if i wrote 123 in the A10 i want excel to find the A9 and add B10 with B9
it's too hard to explain my purpose i hope you understand what i mean
thank you in advance

 

[amirsaeed]

i want excel that every time i write 123 in column A, excel finds the last 123 from column A and then add their B column with each other
for example if i wrote 123 in the A10 i want excel to find the A9 and add B10 with B9
it's too hard to explain my purpose i hope you understand what i mean
thank you in advance

in other word i just want the last 123 from column A not all of them

 

[Aladin Akyurek]

assume i have a table like bellow
[TABLE="width: 500"]
<tbody>[TR]
[TD]456[/TD]
[TD]2486[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]789[/TD]
[TD]6842[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]8624[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]4862[/TD]
[TD]=[/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]9713[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]7139[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]789[/TD]
[TD]1397[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]3971[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]6985[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

i want excel to
for example i'm in column C4
i want to find next 123 below A4(which is 123) then add its B column to B4(which is 4862)
in this example the cell would be A6(which is the next 123 in column A below A4)

i want excel that every time i write 123 in column A, excel finds the last 123 from column A and then add their B column with each other
for example if i wrote 123 in the A10 i want excel to find the A9 and add B10 with B9
it's too hard to explain my purpose i hope you understand what i mean
thank you in advance

in other word i just want the last 123 from column A not all of them

These specifications do not cohere. Care to write down what value or values must obtain given the value of 123 as criterion?

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][/tr]
[tr][td]

1​

[/td][td]X[/td][td]Y[/td][td]Z[/td][/tr]


[tr][td]

2​

[/td][td] 456[/td][td] 2486[/td][td][/td][/tr]


[tr][td]

3​

[/td][td] 789[/td][td] 6842[/td][td][/td][/tr]


[tr][td]

4​

[/td][td] 456[/td][td] 8624[/td][td][/td][/tr]


[tr][td]

5​

[/td][td] 123[/td][td] 4862[/td][td][/td][/tr]


[tr][td]

6​

[/td][td] 456[/td][td] 9713[/td][td][/td][/tr]


[tr][td]

7​

[/td][td] 123[/td][td] 7139[/td][td][/td][/tr]


[tr][td]

8​

[/td][td] 789[/td][td] 1397[/td][td][/td][/tr]


[tr][td]

9​

[/td][td] 456[/td][td] 3971[/td][td][/td][/tr]


[tr][td]

10​

[/td][td] 123[/td][td] 6985[/td][td][/td][/tr]
[/table]