Column A has a list of items that I populate daily.
Column B has dates for when the items were inserted.
I am interested in identifying a specific item when it occurs 2 or more times in a time span (ie: 20 days).
Manually, I sort the data by Column A, visually scan for when the item has occurred more than once, then check to see if the entries occurred in a certain time span.
I am not sure how to begin writing formulas (or would I need VBA?) to do this automatically? I know how to use the countif formula. I think my biggest problem is that I do not know how to identify a range of dates. I know =Today() produces today's date. So =Today()-20 will produce the date 20 days ago. How can I use excel to search data between =Today() and Today() - 20?
Or am I making this more complicated than it seems?
Thanks,
Bookmarks