formula to find which Number has reduced?

[snjpverma]

45 62 50 82 112 In a row, there are numbers stretching from Let's say (A1 to A10). I would like the output result to be the number which has reduced.

In above example, the result should be 50 because when we go from left to right, 50 is a reduction. From 62 it went down to 50.

Any suggestion?

<tbody>
</tbody><colgroup><col></colgroup>

 

[Eric W]

Maybe:

	A	B
1	45	50
2	62	11
3	50
4	82
5	11

<tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula B2 =LOOKUP(2,1/(A2:A5< A1:A4),A2:A5) <tbody> </tbody>

<tbody>
</tbody>

Array Formulas Cell Formula B1 {=INDEX(A2:A5,MIN(IF(A2:A5-A1:A4<0,ROW(A2:A5)-ROW(A2)+1)))} <tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

The B1 formula will find the first time a number is less than the row above, the B2 formula finds the last time a number is less than the row above. If you're sure it can only happen once, I'd use the B2 formula since it's shorter.

 

[wideboydixon]

I'm assuming you mean row and not column (A1:A10 is in a column).

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	45	62	50	82	112	120	125	160	200	256	50
Sheet3

Cell Formulas
Range	Formula
K1	{=IFERROR(INDEX($B1:$J1,MIN(IF($B1:$J1<$A1:$I1,COLUMN($B1:$J1)-COLUMN($B1)+1,COLUMN()))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

WBD