I have lists of data that get data added to them periodically.
I am looking for a formula that will dynamically sort the data pairs by the X value as new data points get added.
I have two rows of data linked from a different sheet.
Something like this:
(blank),7,5,(blank),6,5,7,(blank)
(blank),123,135,(blank),154,143,164,(blank)
I want to create a formula that will reorder the data in the two rows beneath so I can make a scatterplot of the distribution that continuously updates itself as I add data points.
Bookmarks