Results 1 to 4 of 4

Remove duplicates in specific range

Threaded View

  1. 10-07-2024, 04:41 AM #1
    yui_2000
    yui_2000 is offline
    Registered User
    Join Date
    08-31-2024
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    12

    Remove duplicates in specific range

    Hi all,
    I have a table as shown below (attached file)
    Screenshot 2024-10-08 073939.png
    I would like to remove duplicates from A5 to , specifically in the "Index" column. However, if I use the "Remove Duplicates" function in the Table Design tab, it removes duplicates from the entire table, which is not what I want.

    Could you please advise on how to remove duplicates only from that specific range?

    Thank you in advance!
    Attached Files Attached Files
    Last edited by yui_2000; 10-07-2024 at 08:41 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Remove Duplicates from specific column?
    By AircrewX in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-20-2022, 05:58 PM
  2. [SOLVED] VBA Macro to remove specific duplicates based on 2 columns
    By ShawnJun in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-17-2021, 04:09 PM
  3. Remove Duplicates Based on other column Specific Value
    By savinirsb4u in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-15-2021, 08:02 AM
  4. how to combine phrases - remove duplicates - and remove words with specific length
    By niktodorov1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-19-2018, 02:44 PM
  5. How to find duplicates and remove the one with a specific value
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-28-2018, 09:53 AM
  6. [SOLVED] Remove duplicates based on specific words
    By coatesy69 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-26-2016, 08:23 AM
  7. How To Remove Duplicates On Specific Condition?
    By TechnicGeek in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-15-2014, 02:12 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1