find matches in a column

[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

 

[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

 

[Bob Phillips]

Take a look at http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[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

 

[Roger Govier]

Hi Mark

Try wrapping your formula in a Trim() function
=TRIM(your_formula)