+ Reply to Thread
Results 1 to 2 of 2

How to remove multiple year occurrences in a column year

  1. 02-13-2019, 09:56 AM #1
    aijaz75
    aijaz75 is offline
    Registered User
    Join Date
    01-11-2019
    Location
    London
    MS-Off Ver
    2017
    Posts
    4

    How to remove multiple year occurrences in a column year

    I want to delete multiple occurrences of the year from an excel sheet.


    Year Country attacks
    2000 India 2
    2000 India 2
    2001 Iran 3
    2001 Iran 3
    2001 Iran 3

    I want to remove duplicates and only want for e.g. 2000 India 2 not the replicated entry. Same for Iran.

    I have also attached an excel sheet along with this.

    Looking forward to your help.

    Best Regards,
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-13-2019, 10:00 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

    Re: How to remove multiple year occurrences in a column year

    Try the Data tab - Sort and filter - Advanced - Click "Unique records only" - OK
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. [SOLVED] Place Year 1, Year 2, etc. of revenue in proper date column on cash flow forecast
    By Rzzberry in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2017, 01:19 PM
  2. scatterplot of occurrences throughout the year
    By tuckertuesday in forum Excel General
    Replies: 1
    Last Post: 10-29-2015, 07:53 PM
  3. Arranging year-over-year 3rd quarter sales with all customers listed in only one column.
    By excelsos in forum Excel General
    Replies: 4
    Last Post: 08-05-2015, 06:39 PM
  4. Automatically update year interval cycles from year to year
    By trumptight in forum Word Programming / VBA / Macros
    Replies: 8
    Last Post: 08-21-2014, 10:38 PM
  5. Keep month and date but change year to current year and reoccur when new year rolls over.
    By cdixon01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  6. Convert a multiple year list of 365 days/year into an equivalent of 360 days/year
    By lobotomy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-24-2012, 05:39 PM
  7. Bar chart with year on year sales but years are in one column
    By johncassell in forum Excel General
    Replies: 3
    Last Post: 12-30-2010, 07:24 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1