How do I find only the singular rows in a sheet with duplicates?
 

I have two sheets. One from the previous day and one from today. (This is a
daily thing.) Somewhere between yesterday and today, certain rows have been
deleted. I need to know which rows were deleted.

Deleting duplicates leaves me with the sheet from yesterday.

Filtering unique records does the same thing.

Help?

Thank you =)

In an adjacent column in the yesterday sheet, add this formula

=IF(COUNTIF('today'!$A$1:$A$100,A1)=0,"Deleted","" )

and copy down. You c an then filter on deleted items.

--
HTH

Bob Phillips

"Alli" wrote in message
...
I have two sheets. One from the previous day and one from today. (This is
a
daily thing.) Somewhere between yesterday and today, certain rows have
been
deleted. I need to know which rows were deleted.

Deleting duplicates leaves me with the sheet from yesterday.

Filtering unique records does the same thing.

Help?

Thank you =)

I am a little confused. in that you say deleting duplicates leaves the sheet
from yesterday. do you mean that taking todays sheet , and deleting
everything which was on yesterdays sheet, you still have a copy of
yesterday's sheet?

do you mean deleting duplicates from yesterdays sheet doesn't delete anything?

Is someone else deleting the rows? or is it being done automatically?

could you just fill a column each day with a series and just look for
missing numbers the next day?


"Alli" wrote:

I have two sheets. One from the previous day and one from today. (This is a
daily thing.) Somewhere between yesterday and today, certain rows have been
deleted. I need to know which rows were deleted.

Deleting duplicates leaves me with the sheet from yesterday.

Filtering unique records does the same thing.

Help?

Thank you =)