I have 16K plus records with an Auction Date. I need to find the date and amount that is closest to the Auction Date BUT more than 30 days later.
I have calculated a row that shows the difference between the Auction Date and each subsequent sale.
My approach was to us MIN to find the smallest difference that is more than 30 days after the Auction Date. This is the formula I used:
It returns the correct result only once in the sample data. (see image - YELLOW = AUCTION DATE, GREEN = CORRECT INFORMATION, RED=INCORRECT)
Next I need to eliminate from the results any sale of less than $1,000. But I need to get his part of the formula right first.