I would like to find a way to
In Column P, I would like to display the average of all Rows that show a matching date value for Column G, but to pull the average range from row N.
So...lets say, I have Rows 1, 2, 3, 4, 5 and in 1, 2, 4, the date in G is 4/1/20, then in rows 3 and 5, the date in G is 4/3/20. In column P, for each row, I want it to detect the date in G, then average the values in column N for all columns with a matching date value.
In Column P, I would like to display the average of all Rows that show a matching date value for Column G, but to pull the average range from row N.
So...lets say, I have Rows 1, 2, 3, 4, 5 and in 1, 2, 4, the date in G is 4/1/20, then in rows 3 and 5, the date in G is 4/3/20. In column P, for each row, I want it to detect the date in G, then average the values in column N for all columns with a matching date value.