Hello,
In column A I have dates, in column B I have variance amounts for those dates.
I want to find the most current variance from the current date that is over a certain amount and count how many days it has been since that date.
For example, the variance to locate would be greater than $50 or less than ($50)
Then it would calculate how many days have passed since the last variance of $50.
I have a attachment that lays out what I am trying to do.
Thanks for any help,
Nick
Bookmarks