r1998
Board Regular
- Joined
- Sep 9, 2018
- Messages
- 106
Dear friends n respected seniors
I am finding it very difficult to solve this problem, bcoz of blanks in array. i want to get the smallest number from a group of numbers separated by a blank
I have this data in column J starting from j1 , and data in column K is the required result entered manually
Any help appreciated.
Thanks
[TABLE="width: 192"]
<tbody>[TR]
[TD="width: 96, align: right"]500[/TD]
[TD="width: 96, align: right"]500[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]400[/TD]
[TD="align: right"]400[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]300[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]755[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]700[/TD]
[TD="align: right"]300[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]625[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]900[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]800[/TD]
[TD="align: right"]625[/TD]
[/TR]
</tbody>[/TABLE]
I am finding it very difficult to solve this problem, bcoz of blanks in array. i want to get the smallest number from a group of numbers separated by a blank
I have this data in column J starting from j1 , and data in column K is the required result entered manually
Any help appreciated.
Thanks
[TABLE="width: 192"]
<tbody>[TR]
[TD="width: 96, align: right"]500[/TD]
[TD="width: 96, align: right"]500[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]400[/TD]
[TD="align: right"]400[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]300[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]755[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]700[/TD]
[TD="align: right"]300[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]625[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]900[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]800[/TD]
[TD="align: right"]625[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: