I keep running into projects where I need to know if a person had an order within X hrs (or x days) of a separate order. I have attached a sample spreadsheet where I am looking to populate column C with a formula. I'm not sure if vlookup, VBA, or using access would be best to find this. I have tried creating a column combining person id and order date time, then rounding the date times to the nearest 8 hrs. Although that works, it doesn't always flag correctly since the apple order could be at the low end of the rounding interval and the pear order could be at the upper end of the rounding interval. Any thoughts or ideas would be appreciated.
Andrew V. Romero
Bookmarks