PC Review


Reply
Thread Tools Rate Thread

Compare a List

 
 
David Barnhart
Guest
Posts: n/a
 
      17th May 2006
to compare a list of names or numbers... I would always seem to use two
VLOOKUP formulas...

i.e.. find A1 in B:B and find B1 in A:A

does anyone know a better way?


 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      17th May 2006
I use =match()

=isnumber(match(a1,b:b,0))

Will return True if there's a match.

David Barnhart wrote:
>
> to compare a list of names or numbers... I would always seem to use two
> VLOOKUP formulas...
>
> i.e.. find A1 in B:B and find B1 in A:A
>
> does anyone know a better way?


--

Dave Peterson
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare my list to an existing list Beep Microsoft Excel Worksheet Functions 1 18th Dec 2009 06:41 AM
how to compare list Pascal Microsoft VB .NET 2 27th Dec 2008 07:10 PM
Compare List A to List B, Return List B Items Not in List A zwestbrook Microsoft Excel Programming 4 18th Sep 2008 10:32 PM
Compare List<T> =?Utf-8?B?Um9u?= Microsoft C# .NET 1 11th Jul 2006 08:27 PM
compare List A and list B delete the number that occurred more th. =?Utf-8?B?Y29tcGFyZSBsaXN0IEEgYW5kIGxpc3QgQUI=?= Microsoft Excel Worksheet Functions 2 14th Sep 2004 04:32 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:37 PM.