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

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

"Mark Scott" <mark-(E-Mail Removed)> wrote in message
news:fdtxg.17734$(E-Mail Removed) ...

>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
>

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" <mark-(E-Mail Removed)> wrote in message
news:fdtxg.17734$(E-Mail Removed) ...
> 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
>
>

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

"Otto Moehrbach" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
> "Mark Scott" <mark-(E-Mail Removed)> wrote in message
> news:fdtxg.17734$(E-Mail Removed) ...
>
>>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
>>
>
>

Hi Mark

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

--
Regards

Roger Govier


"Mark Scott" <mark-(E-Mail Removed)> wrote in message
news:a_wxg.17490$(E-Mail Removed) k...
> 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
>
> "Otto Moehrbach" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>> "Mark Scott" <mark-(E-Mail Removed)> wrote in message
>> news:fdtxg.17734$(E-Mail Removed) ...
>>
>>>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
>>>
>>
>>
>
>