I need some assistance trying to grab some data from one column and move it to another.
Let’s say I have column P with dates of the month, the data in this column will change at times.
Say 10 samples per day.
Column “Q” has a number for each sample.
I would like to scan “P” and report the date once in Column “R” and then average each days sample and place the average in “S”.
I realize it sounds crazy, but this is what I’m trying to do. Any ideas or suggestions are appreciated.
"P" is date
"Q" is number
"R" is one of each date in Column "P"
"S" is average of the data of each day in "R"
An example is below:
“P” “Q” “R” “S”
[TABLE="width: 268"]
<tbody>[TR]
[TD]5/29/19
[/TD]
[TD]124
[/TD]
[TD]5/29/2019
[/TD]
[TD]124
[/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]124
[/TD]
[TD]5/30/2019
[/TD]
[TD]126
[/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]124
[/TD]
[TD]5/31/2019
[/TD]
[TD]126
[/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]125
[/TD]
[TD]6/1/2019
[/TD]
[TD]137
[/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]126
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]126
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]126
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]127
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]127
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]128
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]128
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]129
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]129
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]128
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]127
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]126
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]125
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]124
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]124
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]126
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]130
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/1/2019
[/TD]
[TD]134
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/1/2019
[/TD]
[TD]137
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/1/2019
[/TD]
[TD]140
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Let’s say I have column P with dates of the month, the data in this column will change at times.
Say 10 samples per day.
Column “Q” has a number for each sample.
I would like to scan “P” and report the date once in Column “R” and then average each days sample and place the average in “S”.
I realize it sounds crazy, but this is what I’m trying to do. Any ideas or suggestions are appreciated.
"P" is date
"Q" is number
"R" is one of each date in Column "P"
"S" is average of the data of each day in "R"
An example is below:
“P” “Q” “R” “S”
[TABLE="width: 268"]
<tbody>[TR]
[TD]5/29/19
[/TD]
[TD]124
[/TD]
[TD]5/29/2019
[/TD]
[TD]124
[/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]124
[/TD]
[TD]5/30/2019
[/TD]
[TD]126
[/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]124
[/TD]
[TD]5/31/2019
[/TD]
[TD]126
[/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]125
[/TD]
[TD]6/1/2019
[/TD]
[TD]137
[/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]126
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]126
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]126
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]127
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]127
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]128
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[TD]128
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]129
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]129
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]128
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]127
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]126
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]125
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]124
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]124
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]126
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/2019
[/TD]
[TD]130
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/1/2019
[/TD]
[TD]134
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/1/2019
[/TD]
[TD]137
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/1/2019
[/TD]
[TD]140
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]