Calculate the most recently entered data in columns?

xor · #1 09-17-2017, 10:35 PM

Here is a version with only one volatile function (see cell C16).
(Helper cells in C10, C11 and C12).

mreynolds1775 · #2 09-18-2017, 05:43 AM

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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting- Only format cells once data is entered	chart3	Excel Programming	1	12-15-2015 11:26 AM
Calculate amount of entered fields	sp1d3r69	Excel	3	01-26-2015 07:35 AM
calculate date if date entered in cell, do nothing if blank	ConfuddledOne	Excel	3	11-07-2014 09:37 AM
Compare columns + calculate difference	Inatic	Excel	1	01-27-2013 08:00 AM
Using data entered in prompt to search database table	BluRay	Word	1	03-25-2011 01:47 AM