Averaging values in Column B based on serial date in column A
1 view (last 30 days)
I have an array that looks like:
col A col B
where column A is the serial date and column B is the respective value. I need a for loop that will average the values in col B that have the same serial date as in column A. Thank you!
ex: serial date: 737585 avg: 1+2+3/3 = 2