I have very large data table in two columns (app. 15000 rows). I need to graph the data. But…here is where I get lost….Column A is a measurement, Column B is, what we will call, displacement. At halfway through the table the displacement value begins to decline. We call that the “break point”.
What I need to do, is at the break point, sort the data (including and below the break point) in ascending order. As exported from the measurement equipment is it in ascending order.
What I am trying to do is look through Column B to find the point at which the data begins to decline, then “grab the data” in columns A and B and sort it in an Ascending manner by Column A. Everything above the break point is to remain as entered
Here is an example of raw data:
Column A Column B
4805.037 114.562
4805.037 114.562
4812.496 114.584
4811.029 114.594
4829.736 114.596
4783.812 114.59
4513.003 114.57
3991.883 114.55
3837.433 114.53
3819.835 114.512
Sorted Data:
Column A Column B
4805.037 114.562
4805.037 114.562
4812.496 114.584
4811.029 114.594
4829.736 114.596
3819.835 114.512
3837.433 114.53
3991.883 114.55
4513.003 114.57
4783.812 114.59
Notice the order after sorting...
Reply With Quote
