LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Tom is offline
external usenet poster
 
Posts: 17
Default How to print out matching names?

I have two files each holds a long list of names and other personal
information.
The names are located in Column A. How can I compare the list of names and
ask Excel to print out on Column B of File2 the word "match" if an exact
match is found, but nothing if it is not an exact match, like:

File1 File2
Down Down match
Downes
Downer

Thank you for your help.

Regards,
Tom


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Matching Names Mal Excel Discussion (Misc queries) 7 January 4th 12 12:45 PM
Matching Names Tarig New Users to Excel 1 November 8th 09 01:13 PM
Matching names Richard Excel Discussion (Misc queries) 1 April 24th 07 11:50 PM
Matching names in two columns [email protected] Excel Discussion (Misc queries) 2 March 29th 07 05:01 AM
Sorting and matching rows of names with Socials with master list and eliminating the extra names Giacomo Excel Worksheet Functions 1 March 10th 07 01:52 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"