Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Pittsford,NY
    Posts
    869
    Thanks
    512
    Thanked 35 Times in 27 Posts

    Finding common symbols in 2 spreadsheets

    Using Excel 2007, on my d:/desktop, I have 2 speadsheets. One called "Fish" has 461 entries in col. B.
    The 2nd one, called "House" has 1029 entries in col. A.

    I want to find the entries that are common to both spreadsheets, and put "yes" for the matches in col. H
    of House.

    Thanks for helping me, and saving me a lot of time.

    Dick

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts
    Hi Dick

    Make sure you have both workbooks open.
    Then, in workbook [House], in cell [H1] put the following formula:
    =IF(ISNA(MATCH(A1,[Fish.xlsx]Sheet1!$B:$B,FALSE)),"","yes")
    ..now copy this formula down column [H] to row 1029 (or however many entries you have).

    After copying the formulas down, you can 'convert' them to values by copying the block of formulas and using edit-pastespecial-values.

    zeddy

  3. The Following User Says Thank You to zeddy For This Useful Post:

    Dick-Y (2012-05-04)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •