Hi,
I have data as below:
1.2 4.3 0.2 92.7 4.6 1.3 112.7 2.2 4.6 20.2 4.1 3.0 120.4 5.3 2.6 11.1 4.2 2.3 52.3 4.0 2.0 32.3 4.0 2.0 10
Given point is 12. Based on 4th column, I want to select two data above 12, which are minimum values in column 4, two data below 12 (which are minimum, in column 4). My desired output as below:
1.2 4.3 0.2 92.7 2.2 4.6 20.2 4.1 3.0 120.4 5.3 2.6 12.3 4.0 2.0 3
Best Answer