Yet, another Excel question

5_time_champ · December 2, 2009, 6:49pm

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

Is there anyway to “extract” that unique record?

Giles · December 2, 2009, 6:58pm

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 · December 2, 2009, 7:04pm

Excel has a feature to filter “unique” records: Microsoft Support

Munch · December 2, 2009, 7:27pm

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 · December 2, 2009, 8:50pm

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