ST Alpha - "Excel Question Inside" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 169

Excel Question Inside

Posted by Dano (aka dano) Feb 19 '09, 08:02

I've got an Excel spreadsheet with about 1700 rows.
One of the columns is email address.
I need to find which email addresses are duplicates.
(I don't want to eliminate duplicates because they need to be there based on other columns.)

What I would normally do is sort the entries by email address and scan by sight for duplicates.

Is there some function I can use instead?

Responses:

here is one way - decline Feb 19, 08:09
sort by email address, then make a new column next to the email address - JaxSean Feb 19, 08:05
here's what i do, but it's not very efficient - prayformojo Feb 19, 08:04 3
- Instead of 'Yes','No' can I do 'Monkey','Robot'? -- nm - Dano Feb 19, 08:07
- If you copy the column, then Paste Special and choose Values, it overwrites the formula. -- nm - JaxSean Feb 19, 08:06 1
  - really? cool, i'll remember this! -- nm - prayformojo Feb 19, 08:08

Post a message top

Excel Question Inside

Replies are disabled on threads older than 7 days.