Results 1 to 13 of 13

Exception to remove duplicates function

Threaded View

  1. #1
    Registered User
    Join Date
    01-24-2019
    Location
    Chennai
    MS-Off Ver
    2013
    Posts
    96

    Exception to remove duplicates function

    Hello,

    I need a exception code for not deleting below content of my packing list.

    Let me be clear I wrote below function to clear all unwanted duplicated from my packing list. Unfortunately, some parts has same content as Gross weight and Net weight which below code consider as duplicates and delete it off.

    I want some code exception to surpass this content alone. Enclosed spreadsheet which has gross weight content which starts with lots of space as it's imported from a text file.

    Need your support please


    Sub DeleteRows()

    Range("A1").Select
        ActiveSheet.Range(Selection, ActiveCell.SpecialCells(xlLastCell)).RemoveDuplicates Columns:=1, Header:=xlYes
    End Sub
    Attached Files Attached Files
    Last edited by priyadharshane; 02-16-2019 at 06:04 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Remove Duplicates Function
    By Prodetik in forum Excel General
    Replies: 2
    Last Post: 10-04-2016, 05:39 PM
  2. [SOLVED] Remove Duplicates Function for Single Cells
    By the_red_engine in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-17-2016, 08:20 PM
  3. Remove Duplicates Function
    By Keshypops in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-17-2015, 06:59 AM
  4. Remove duplicates function not removing duplicates
    By Berilium2 in forum Excel General
    Replies: 3
    Last Post: 04-01-2015, 06:55 AM
  5. [SOLVED] function to remove duplicates from different sheets
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-03-2014, 08:03 AM
  6. Top 40 values with duplicates and with exception
    By Fabienne88 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-02-2013, 07:57 AM
  7. How to use find/replace to remove back carriages BUT make exception to bullet points?
    By WoW_Excel_girl88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-16-2012, 12:27 PM

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