vlookups w/i time frame

[aromero]

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

[xladept]

This seems to work:

Please Login or Register  to view this content.

[aromero]

Thanks, this is working well. I'll be curious to see how it performs with large data sets. Are nested for loops faster than vlookups?

[xladept]

You're welcome and thanks for the rep!

I don't know about nested loops and vlookups but vlookups can get bound on large data sets.

If it's too slow on your large set, we could code it into an array

Please Login or Register  to view this content.