Hello, Does anyone happen to know how to make wild card functions within excel? For example, I need to set up a function that would compare all data in a specific column to all other data in the same column (or perhaps another one). For example, I'd want to have each date in the column compared to every other date in the column, and only return results if the dates are within a certain threshold of each other (+/- 3 days, 5 days, etc).

If I can figure out how to do this, I'll then have to have the informaiton compared against an additional column to return a result.
Perhaps there is a better way to accomplish this outside of functions? In any case, I'd greatly appreciate it if you could point me in the right direction.