Finding EXACT matches within separate rows

**IowaTracy** · 08-11-2006, 10:20 AM

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** · 08-11-2006, 12:22 PM

Is this question one that is too easy and I should be able to figure out on my own or so hard that nobody is willing to tackle it?

**IowaTracy** · 08-12-2006, 09:58 AM

I want to bump this up one more day to see if I can get any response.

Thank you

IowaTracy

Biff · 08-12-2006, 02:35 PM

Hi!

Do you want to go back 60 *DAYS* based on the date or 60 *ENTRIES* ?

What if there isn't 60 days worth of entries?

Do you add a new row data each day or might you add more than one row of
data each day?

Are there any empty rows within the data range?

Biff

"IowaTracy" <IowaTracy.2cdqfr_1155306305.7735@excelforum-nospam.com> wrote
in message news:IowaTracy.2cdqfr_1155306305.7735@excelforum-nospam.com...
>
> 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
>

**IowaTracy** · 08-12-2006, 10:47 PM

Hi Biff, thanks for the reply.

I want to go back 60 DAYS based on the date entered. There will be anything from multiple entries on a single day to no entries on a given day.

After the spreadsheet is 60 days old then there will always be 60 days worth of entries.

So as mentioned above there might not be any entries one a day or there may only be one or there may be many. There will be no empty rows. The entries will be made as needed.

This spreadsheet is being used to track deficiencies corrected in an inspection process so every day varies.

Bottom line is that as we enter more entries is becomes hard to look back 60 days to see if there is a repeat occurance of the exact same entry.

Thanks again for your help.

Tracy

Originally Posted by Biff

Hi!

Do you want to go back 60 *DAYS* based on the date or 60 *ENTRIES* ?

What if there isn't 60 days worth of entries?

Do you add a new row data each day or might you add more than one row of
data each day?

Are there any empty rows within the data range?

Biff

"IowaTracy" <IowaTracy.2cdqfr_1155306305.7735@excelforum-nospam.com> wrote
in message news:IowaTracy.2cdqfr_1155306305.7735@excelforum-nospam.com...
>
> 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
>

Biff · 08-13-2006, 02:00 AM

Ok, just a couple more questions........

This is fairly complicated but it can be done. However, depending upon how
big you file is and other factors this may slow things down as far as
calculation times. So, how big is your file? How many rows of data will this
particular sheet have? If it's 1000's then this (what I've come up with)
won't work very well. It'd be too slow.

Would it be possible for you to send me a copy of your file so I can see
exactly what I'm dealing with? If so, my address is:

xl can help at comcast period net

Remove "can" and change the obvious.

Biff

"IowaTracy" <IowaTracy.2cgjlj_1155437413.1335@excelforum-nospam.com> wrote
in message news:IowaTracy.2cgjlj_1155437413.1335@excelforum-nospam.com...
>
> Hi Biff, thanks for the reply.
>
> I want to go back 60 DAYS based on the date entered. There will be
> anything from multiple entries on a single day to no entries on a given
> day.
>
> After the spreadsheet is 60 days old then there will always be 60 days
> worth of entries.
>
> So as mentioned above there might not be any entries one a day or there
> may only be one or there may be many. There will be no empty rows. The
> entries will be made as needed.
>
> This spreadsheet is being used to track deficiencies corrected in an
> inspection process so every day varies.
>
> Bottom line is that as we enter more entries is becomes hard to look
> back 60 days to see if there is a repeat occurance of the exact same
> entry.
>
> Thanks again for your help.
>
> Tracy
>
> Biff Wrote:
>> Hi!
>>
>> Do you want to go back 60 *DAYS* based on the date or 60 *ENTRIES* ?
>>
>> What if there isn't 60 days worth of entries?
>>
>> Do you add a new row data each day or might you add more than one row
>> of
>> data each day?
>>
>> Are there any empty rows within the data range?
>>
>> Biff
>>
>> "IowaTracy" <IowaTracy.2cdqfr_1155306305.7735@excelforum-nospam.com>
>> wrote
>> in message
>> news:IowaTracy.2cdqfr_1155306305.7735@excelforum-nospam.com...
>> >
>> > 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
>> >
>
>
> --
> IowaTracy
> ------------------------------------------------------------------------
> IowaTracy's Profile:
> http://www.excelforum.com/member.php...o&userid=37395
> View this thread: http://www.excelforum.com/showthread...hreadid=570766
>

**IowaTracy** · 08-23-2006, 09:57 AM

Hi, sorry for the week lag. I was in Florida on vacation with my kids and had no access to the forum.

I sent you an email. You may reply there.

Thank you sooo much,

Tracy