+ Reply to Thread
Results 1 to 3 of 3

Match values from two columns having similar values in 1st column if not error

  1. #1
    Registered User
    Join Date
    05-20-2014
    Posts
    10

    Match values from two columns having similar values in 1st column if not error

    Hi,

    can some one please try this out.

    there will be two columns.1st column have values which may be similar values.if similar value exist in 1st column then compare adjacent rows of similar values to check they are also similar or not.

    i attached an excel example to tryout.it may contain 1000 rows,but practice purpose i just included 10.

    Thank You

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Match values from two columns having similar values in 1st column if not error

    No example attached.
    You probably need to define "similar".
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Match values from two columns having similar values in 1st column if not error

    No example attached.
    You probably need to define "similar" too.

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Match values from two columns having similar values in 1st column if not error

    I think you have forgotten to attach the file.
    Please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 12-30-2013, 08:15 AM
  2. Replies: 5
    Last Post: 10-26-2013, 01:03 PM
  3. Match to columns in different sheets and pull the 3rd column values
    By Pats83 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2013, 11:45 AM
  4. Search columns with similar values
    By vijay2482 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2010, 08:18 AM
  5. Compare columns for similar values
    By uncleslinky in forum Excel General
    Replies: 1
    Last Post: 04-07-2009, 02:08 AM

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