Hello,
I have some data for "drug_level", that I need to sort based on the day column, but I want the first two results to always correspond to the drug_level on the "screening" and "baseline" days, and then all other days sorted in increasing order. Also if there are more than one values for a certain day, I want them to be averaged. Here is an example XL2BB:
Thanks for any input.
I have some data for "drug_level", that I need to sort based on the day column, but I want the first two results to always correspond to the drug_level on the "screening" and "baseline" days, and then all other days sorted in increasing order. Also if there are more than one values for a certain day, I want them to be averaged. Here is an example XL2BB:
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Before sort | After sort | |||||||
2 | Day | Drug_Level | Day | Drug_Level | |||||
3 | 2 | 8620223 | screening | 6191016 | |||||
4 | 6 | 7951988 | baseline | 1238085 | |||||
5 | 3 | 8120872 | 2 | 8620223 | |||||
6 | 9 | 1209028 | 3 | 8120872 | |||||
7 | baseline | 5549070 | 5 | 932997 | |||||
8 | 7 | 1262228 | 6 | 6792422 | |||||
9 | 14 | 1061300 | 7 | 1262228 | |||||
10 | screening | 1238085 | 9 | 2159194 | |||||
11 | 30 | 33736 | 14 | 925183.5 | |||||
12 | 22 | 3576752 | 22 | 3576752 | |||||
13 | 9 | 3109360 | 25 | 71212 | |||||
14 | 5 | 932997 | 30 | 33736 | |||||
15 | 25 | 71212 | |||||||
16 | 14 | 789067 | |||||||
17 | baseline | 6832962 | |||||||
18 | 6 | 5632856 | |||||||
19 | |||||||||
Sheet1 |
Thanks for any input.