|Line||Area||Product (Avg.)||Set Marker|
This is my first post here, and I was wondering if anyone could help me do the following:
I am looking to try to perform a function where the values in the "area" column are taken and averaged into the "product" column based on the location of my "set marker".
For example, Line 1 has a marker whereas Line 2 does not - therefore the area value of 30 is average between Line 1 and Line 3 (which has a marker). Keep in mind that Line 3 also shares an area value with Line 4, etc. which also has a marker.
Any ideas would be really appreciated.