after review, I think it may simplify the process to do something similar to attached... I can then find the desired sales rates via VLOOKUP later...
desired endstate would be to have a rolling average displayed in C:C of the last 3 entered data points for that row.
Thanks in advance for any help!
|