PDA

View Full Version : Yet, another Excel question

5 time champ
12-02-2009, 12:49 PM
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
12-02-2009, 12:58 PM
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
12-02-2009, 01:04 PM
Is there anyway to "extract" that unique record?


Excel has a feature to filter "unique" records: http://office.microsoft.com/en-us/excel/HA010346261033.aspx
Munch
12-02-2009, 01:27 PM
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
12-02-2009, 02:50 PM
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.