I am trying to set up a formula that counts info in 2 columns. Column A consists of names of places and Column B consists of dates. I want to be able to count all of times a place in column A appears between dates in Column B. In other words, each time a place sends a package, I enter them into a row, one column of that row being their name and another column of that row being the date in which they sent the package. I want to be able to automatically tally the number of packages received per month from each place. The month factor would be based on the dates entered into Column B.
Any ideas on how to do this and I would be extremely grateful!
Example:
Column A Column B
Center x 2/1/2008
Center Z 2/2/2008
Center X 2/7/2008
Center Y 2/7/2008
Center Z 3/1/2008
Center Y 3/2/2008
Any ideas on how to do this and I would be extremely grateful!
Example:
Column A Column B
Center x 2/1/2008
Center Z 2/2/2008
Center X 2/7/2008
Center Y 2/7/2008
Center Z 3/1/2008
Center Y 3/2/2008