find matches in a column

M

Mark Scott

I am using excel to add users to AD, I need to have a function that will
look through my username column and find matches and highlight them, can
anyone advise?

Regards

Mark
 
O

Otto Moehrbach

Let's say your data is located in Column A starting in A1. In a blank
column, enter this formula in row 1:

=If(Countif(A:A,A1)=1,True,False)

Drag this to bottom of table. Values appearing more than once appear as
False. HTH Otto
 
M

Mark Scott

Thanks Otto and Bob! another one, if I may?

I get a spreadsheet with the names entered ie Smth Jane and I concatenate
them with the 2 digit year to get a username: 06SmithJ, what I am finding is
that if there is a space at the end of the surname colum it gets
concatenated to 06smith J how can I get this space removed?

Cheers

Mark
 
Top