Please refer the attachment
Hello
I get raw data in the form as seen in the columns A and B.
From this data, I have to select median points corresponding to each integer.
For example, if we see in column A, I need one median point from 18..., one from 19…, one from 20… and so on.
The number of data points vary for each number.
But the numbers are always in increasing (or decreasing) order.
I can do it one by one, but real data has around 5000 data points. Each number has 45-50 data points and number are also from, for example 18 - 80.
So I am looking for a code that I can apply to get median points for column A and corresponding points to them from column B.
Bookmarks