N Natalie Aug 11, 2003 #1 How do I match up text in column B with it's same name match in Column A? Is this possible?
R Rob Aug 11, 2003 #2 Could you please give us more to go on.. exactly what are you trying to accomplish.. give an example.
Could you please give us more to go on.. exactly what are you trying to accomplish.. give an example.
N Natalie Brown Aug 11, 2003 #3 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!
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 Aug 11, 2003 #4 =SUM(COUNTIF($A$1:$A$500,"=" & (B1:B500))) Array Entered (control + shift + enter) Dan E
