Matching list in excel

N

Natalie

How do I match up text in column B with it's same name
match in Column A? Is this possible?
 
R

Rob

Could you please give us more to go on.. exactly what are
you trying to accomplish.. give an example.
 
N

Natalie Brown

I have a list of companies in column A that is my
companies clients and in column B I have a list of the
Fortune 500 companies. I need to match up the companies
that my company has with those companies on the fortune
500 list. Does this help?

Thanks!
 
D

Dan E

=SUM(COUNTIF($A$1:$A$500,"=" & (B1:B500)))
Array Entered (control + shift + enter)

Dan E
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto match destination formatting for Mac 0
Word macro that can call cells out of Excel for a find and replace 0
Match style 0
Extracting a cell value 2
Set-MsolUserLicense cmdlet gives error 'A parameter cannot be found that matches parameter name TenantId' 0
Convert Number to Text for Index/Match 1
Match issue 3
adding multiple values from matched search results 3

Top