I am trying to find the next closest date in a set of unsorted data. If the ID in column AD matches, and the name in column J matches, I want to return the next date in the array to the cell in column I. This formula would be in column V, which Iíve filled out with the correct result I want pulled.
I hope this makes sense, I just want to pull the next date given two criteria.
Column I Column J Column V Column AD 1/23/2013 Amp 12/25/2013 2A 9/23/2013 Ben 12/26/2013 3A 8/2/2013 Ben 11/5/2013 2A 12/25/2013 Amp Blank 2A 12/26/2013 Ben Blank 3A 11/5/2013 Ben Blank 2A 1/2/2013 Amp 1/23/2013 2A