Arrange and Seqance Value By The Length

[sanju2323]

A	Length	B	Length	Sort & Arrange Data By Length
				Required Data
455915.210	10.000	455797.536	15	455790.023	5
455905.557	20.000	455790.023	5	455915.210	10
455898.910	30.000	455781.210	25	455797.536	15
455888.044	40.000	455773.414	85	455905.557	20
455881.357	50.000	455768.432	45	455757.244	24
455870.547	60.000	455764.583	77	455781.210	25
455863.575	70.000	455763.990	91	455762.802	28
455856.131	80.000	455763.478	105	455898.910	30
455850.238	90.000	455762.802	28	455888.044	40
455840.065	100.000	455762.218	84	455761.732	41
455839.316	110.000	455761.732	41	455768.432	45
455833.056	120.000	455761.150	66	455751.483	46
455827.908	130.000	455760.505	67	455881.357	50
455820.185	140.000	455759.243	88	455870.547	60
455814.451	150.000	455757.244	24	455761.150	66
455805.390	160.000	455751.483	46	455760.505	67
				455863.575	70
				455764.583	77
				455856.131	80
				455762.218	84
				455773.414	85
				455759.243	88
				455850.238	90
				455763.990	91
				455840.065	100
				455763.478	105
				455839.316	110
				455833.056	120
				455827.908	130
				455820.185	140
				455814.451	150
				455805.390	160

<tbody>
</tbody>

​

Please Give Me Excel Formula How to Do That .

 

[sanju2323]

Please Give Me Formula How To Do That

 

[Andrew Poulsom]

In F3 copied down:

=SMALL((B$3:B$18,D$3:D$18),ROWS(F$3:F3))

and in E3 copied down:

=IFERROR(INDEX(A$3:A$18,MATCH(F3,B$3:B$18,FALSE)),INDEX(C$3:C$18,MATCH(F3,D$3:D$18,FALSE)))

 

[sanju2323]

In F3 copied down:

=SMALL((B$3:B$18,D$3:D$18),ROWS(F$3:F3))

and in E3 copied down:

=IFERROR(INDEX(A$3:A$18,MATCH(F3,B$3:B$18,FALSE)),INDEX(C$3:C$18,MATCH(F3,D$3:D$18,FALSE)))

Thanks Its works