Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 8 of 8

Thread: Count of Duplicate Entries

  1. #1
    Join Date
    11th September 2006
    Posts
    14

    Count of Duplicate Entries

    hi all,

    my first post here. i have searched thoroughly for this but couldnt find anything so here is my dilemma..

    there are unique entries like AU0896 etc. that are repeated in my list.
    my job is to find how many unique entries there are and add the count at the end so, basically if there are 6 AU0896 entries, then I must create a AU08966 value.

    thanks in advance...

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Extract Unique Entry And Edit This

    Hi yyac8138,

    Welcome to OzGrid!!

    Try Data > Filter > Advanced Filter to extract the unique values. To count the entries use COUNTIF

    Post back if you need more help.

    HTH
    Last edited by Dave Hawley; September 14th, 2006 at 16:00.

  3. #3
    Join Date
    11th September 2006
    Posts
    14

    Re: Extract Unique Entry And Edit This

    hi,

    thanks, except maybe i should have clarified this more but i need to write a macro for this.. and surprisingly i cant use the filter on it.

    weird.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Extract Unique Entry And Edit This

    i cant use the filter on it.
    It's Advanced Filter not Filter

    You can automate the process by turn on the Macro recorder and record the Macro while doing all this activities.

    HTH

  5. #5
    Join Date
    11th September 2006
    Posts
    14

    Re: Extract Unique Entry And Edit This

    yeh somehow i cant apply any sort of filter on it at all because when i go to data and filter, the option is not available

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Extract Unique Entry And Edit This

    Hi,

    See the attachment.

    HTH
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  7. #7
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,784

    Re: Extract Unique Entry And Edit This

    Quote Originally Posted by yyac8138
    yeh somehow i cant apply any sort of filter on it at all because when i go to data and filter, the option is not available
    Try unprotecting the Worksheet.

  8. #8
    Join Date
    11th September 2006
    Posts
    14

    Re: Count of Duplicate Entries

    hello again...

    hooray it worked...

    thanks to you all for helping =)

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Merge Duplicate Entries For Count Or Sum
    By TC777 in forum Excel General
    Replies: 4
    Last Post: January 17th, 2008, 16:01
  2. Once-off And Duplicate Entries
    By AEther in forum Excel General
    Replies: 1
    Last Post: November 16th, 2006, 17:59
  3. Stop Duplicate Entries
    By steve1262 in forum Excel General
    Replies: 4
    Last Post: August 25th, 2006, 10:28
  4. Duplicate Entries
    By Analyst84 in forum Excel General
    Replies: 1
    Last Post: May 13th, 2004, 05:13
  5. Deleting Duplicate Entries
    By bearcub in forum Excel General
    Replies: 19
    Last Post: February 12th, 2003, 06:06

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
  •  
porno