Yet, another Excel question

[5 time champ]

I have the output of an Address Book, trying to find which records may have been added or modified in the last month or so.

I have two Excel spreadsheets containing:
First Name, Last Name, Email Address

I have sorted them and then merged them so I have

Andrew Adams andrewadams@adam.com
Andrew Adams andrewadams@adam.com
Bart Adams bartadams@smith.com
Bart Adams bartadams@smith.com
John Atwood jatwood@msn.com
Becky Brown bbrown@brown.com
Becky Brown bbrown@brown.com

Is there anyway to "extract" that unique record?

[Giles]

If the data is in column A, then in the second cell of another column put:

=IF(OR(A1=A2,A2=A3),"","This is new")

Copy that to the other cells in that column that have a cell in column A.

Look for the cell with "This is new" in it.

[Ruminator]

Originally Posted by 5 time champ

Is there anyway to "extract" that unique record?

Excel has a feature to filter "unique" records: http://office.microsoft.com/en-us/ex...346261033.aspx

[Munch]

What if you have:

FiveTime Champ Five @ Time.Champ
FiveTime Champ Five @ TimeChamp.com
FiveTime Champ FiveTimeChamp @ gmail.com
FiveTime Champ 5 @ timechamp.com

What do you want extracted there? Personally, I'd do a pivotchart.

[5 time champ]

Originally Posted by Giles

If the data is in column A, then in the second cell of another column put:

=IF(OR(A1=A2,A2=A3),"","This is new")

Copy that to the other cells in that column that have a cell in column A.

Look for the cell with "This is new" in it.

That did it, thanks. As much as a I rag on Micro$oft, Excel is a very useful & powerful application.