Flagging Duplicates in Excel
I have a field that is sorted...happens to contain email addresses...and I want to eliminate duplicates. My thought was to create a new column and use =if(e1=e2,"duplicate","uni
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
BTW it was written in Office 365 but I have tried copying it into Excel 2010 but to no avail.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
> Is there any way to remove the formula and keep the text?
Yes there is, BobbaBuoy. Did you read first suggestion (from Steveo)?
Yes there is, BobbaBuoy. Did you read first suggestion (from Steveo)?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@tel2, it did the same as before...kept the formulas and then changed the values (duplicate or unique) based on their new location). I did not try Paste special. I will do that this evening.
I really appreciate all the help. Thanks!
I really appreciate all the help. Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Very helpful!
ASKER