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


--
IowaTracy
------------------------------------------------------------------------
IowaTracy's Profile: http://www.excelforum.com/member.php...o&userid=37395
View this thread: http://www.excelforum.com/showthread...hreadid=570766