Hi,

I have a simple spreadsheet where as there are 5 columns (date, name, location, equipment, and action).

New rows are created each day as new data is collected.

After each entry (or each new day of entries) I would like to be able to see if any new entry matches exactly (except for the date) within a certain period of time. ie 60 days.

EX:

03/01/2006 John Kitchen Sink Re-Cleaned
03/02/2006 Tim Kitchen Sink Re-Cleaned (would not be a match)
03/03/2006 John Kitchen Sink Re-Cleaned (would be a match with the first entry)

Ideally I would like the results to display on another sheet/tab but just having the matched row(s) highlighted or change colors would be fine.

Can anyone please help me to get started?


Thank you so much,

Tracy