I am trying to have a moving average of 3 cells. To set the scene I will describe what my trouble is. I have column A with many different names but most repeat 10 times, some do not repeat. Column B has numbers. I want to take the moving average of 3 cells for person x, but when person y starts I want the moving average to stop and do moving average for person y. So, person x first 3 averages would be N/A and the fourth would average the first 3. Then when person y starts I want their first 3 to be N/A and then start at the fourth. A problem is person z has only 2 data rows so they will not have an average due to lack of data.
Thanks for the help in advance!