Is there a way to scan a column and pick out when things are different, then copy them to another cell?
I have column B which is all dates, about 4000 cells, but only maybe 10 dates.
288 samples per day, so each date is show 288 times, but there may not always be 288 samples of each.
There may only be 100 samples of the first listed date, but as you scroll down the column, the next day will begin and there will be another date.
I’m trying to scan the column B, and then put one cell for each date in column D, so that I can create an average of the samples for each day in column B.
Example
Column “B” Column “D” Column “E”
2019-06-01 2019-06-01 Average of all 2019-06-01
2019-06-01 2019-06-02 Average of all 2019-06-02
2019-06-01 2019-06-03 Average of all 2019-06-03
2019-06-01
2019-06-01
2019-06-02
2019-06-02
2019-06-02
2019-06-02
2019-06-03
2019-06-03
2019-06-03
2019-06-03
I have column B which is all dates, about 4000 cells, but only maybe 10 dates.
288 samples per day, so each date is show 288 times, but there may not always be 288 samples of each.
There may only be 100 samples of the first listed date, but as you scroll down the column, the next day will begin and there will be another date.
I’m trying to scan the column B, and then put one cell for each date in column D, so that I can create an average of the samples for each day in column B.
Example
Column “B” Column “D” Column “E”
2019-06-01 2019-06-01 Average of all 2019-06-01
2019-06-01 2019-06-02 Average of all 2019-06-02
2019-06-01 2019-06-03 Average of all 2019-06-03
2019-06-01
2019-06-01
2019-06-02
2019-06-02
2019-06-02
2019-06-02
2019-06-03
2019-06-03
2019-06-03
2019-06-03