I need to count if a unique id has been used within the previous 90 days of the most recent used date. It is considered a duplicate
if it has been used within the previous 90 days, however it if was used greater than 90 days it is not a duplicate. I need this to run off the date the unique Id was used, and not off of today’s date.
Column A is date
Column B is unique id
Column C would then be the formula.
Column A is date
Column B is unique id
Column C would then be the formula.