+ Reply to Thread
Results 1 to 5 of 5

Compare two columns to check if difference is less then 100 then delete entire row..

  1. #1
    Registered User
    Join Date
    05-01-2014
    Location
    Dhaka
    MS-Off Ver
    Excel 2010
    Posts
    3

    Thumbs up Compare two columns to check if difference is less then 100 then delete entire row..

    Compare two columns to check if difference is less then 100 then delete entire row..
    excel.png

    Anyone kind enough to help

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

    Re: Compare two columns to check if difference is less then 100 then delete entire row..

    Try this........
    Please Login or Register  to view this content.
    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.

  3. #3
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Compare two columns to check if difference is less then 100 then delete entire row..

    Try this:

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    05-01-2014
    Location
    Dhaka
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Compare two columns to check if difference is less then 100 then delete entire row..

    I just wrote myself this not sure if it will work
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    05-01-2014
    Location
    Dhaka
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Compare two columns to check if difference is less then 100 then delete entire row..

    Thank you all. my problem solved.

+ 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. Compare two cells, if blank delete entire row
    By taichi56 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2013, 02:05 PM
  2. Replies: 6
    Last Post: 05-24-2012, 09:14 AM
  3. Compare Columns List difference
    By Wskip49 in forum Excel General
    Replies: 1
    Last Post: 02-11-2012, 10:53 PM
  4. Replies: 5
    Last Post: 01-06-2012, 04:15 AM
  5. Compare Columns and Find Difference
    By waki01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2008, 02:05 PM

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