Hello,
This is a simplified version of the data table that I have:
Date Color
February 5, 2013 Brown
February 6, 2013 Orange
February 7, 2013 Red
February 11, 2013 Gray
February 25, 2013 Orange
February 26, 2013 Beige
March 11, 2013 Gray
March 18, 2013 Red
March 25, 2013 Orange
I have created a frequency table based on this information that looks like this:
Color Freq.
Brown 1
Orange 3
Red 2
Gray 2
Beige 1
I would like to add a third column to my frequency table that will subtract the differences between the dates in my data table (from newest to oldest) and average the differences between those values, resulting in a column like this (that I calculated manually for demonstration purposes):
Average Number of Days Between Colors
0
23.5
39
28
0
Is there any type of formula that can do this? I'd prefer to use an array in the spreadsheet itself, but would do some VBA if that is the only way possible, as I don't have much experience with it but could probably muddle my way through...
Thanks so much in advance for help with this!
Amy
Bookmarks