Results 1 to 3 of 3

Need help for macro to find and count matches in Excel

Threaded View

  1. #1
    Registered User
    Join Date
    01-20-2013
    Location
    Varna,Bulgaria
    MS-Off Ver
    Excel 2003
    Posts
    2

    Need help for macro to find and count matches in Excel

    I need to create a macro to do the follow:
    In a Excel table
    A B C
    ------
    a
    b
    c
    d
    i will paste a data in a column C for instance

    A B C
    ------
    a 0 b
    b 0 b
    c 0 f
    d 0

    The result I'm looking for is to find number of matches in A and B and if there is not match to add element to column A as follow:
    A B C
    -----
    a 0 b
    b 2 b
    c 0 f
    d 0
    f 1
    Last edited by Dorian65; 01-20-2013 at 02:37 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1