Microsoft Office Forums


Reply
Thread Tools Display Modes

find matches in a column

 
 
Mark Scott
Guest
Posts: n/a

 
      07-25-2006, 06:15 PM
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


 
Reply With Quote
 
 
 
 
Otto Moehrbach
Guest
Posts: n/a

 
      07-25-2006, 06:34 PM
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
>



 
Reply With Quote
 
Bob Phillips
Guest
Posts: n/a

 
      07-25-2006, 06:36 PM
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
>
>



 
Reply With Quote
 
Mark Scott
Guest
Posts: n/a

 
      07-25-2006, 10:32 PM
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
>>

>
>



 
Reply With Quote
 
Roger Govier
Guest
Posts: n/a

 
      07-25-2006, 11:43 PM
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
>>>

>>
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query that gives me all matches and non matches John J. Access Newsgroup 4 10-12-2008 06:04 PM
FIND TEXT in Column Andrew Access Newsgroup 1 03-28-2008 10:17 AM
Find Smallest value in column azidrane Excel Newsgroup 3 06-07-2006 05:32 AM
Can't find Column A mkingsley Excel Newsgroup 2 08-02-2005 07:23 PM
Need to find last cell in a column Robert Adach Excel Newsgroup 6 08-01-2005 01:02 PM



All times are GMT. The time now is 02:08 PM.