Announcement

Collapse
No announcement yet.

Count of Duplicate Entries

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

  • #2
    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, 16:00.
    Kris

    ExcelFox

    Comment


    • #3
      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.

      Comment


      • #4
        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
        Kris

        ExcelFox

        Comment


        • #5
          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

          Comment


          • #6
            Re: Extract Unique Entry And Edit This

            Hi,

            See the attachment.

            HTH
            Attached Files
            Kris

            ExcelFox

            Comment


            • #7
              Re: Extract Unique Entry And Edit This

              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.

              Comment


              • #8
                Re: Count of Duplicate Entries

                hello again...

                hooray it worked...

                thanks to you all for helping =)

                Comment

                Working...
                X