Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    8

    Unanswered: Find Duplicate and insert

    Hi,

    This is kumar. I have a scenario. IN a column there are duplicates i.e each value may be duplicated 3 0r 4 times

    . i want to retain the unique value in the first column and the duplicates in the next adjacent column. with a click

    of a button using forms (access VBA)

    aa
    aa
    bb
    bb
    cc
    cc
    aa
    dd
    dd
    dd
    dd
    cc


    Answer should be


    UNIQUE DUP1 DUP2
    aa aa aa
    bb bb
    cc cc cc
    dd dd dd


    The Duplicates should be replicated in the adjacent cells based on the count(duplicates)

  2. #2
    Join Date
    Feb 2012
    Posts
    76
    How about:

    UNIQUE CNT
    aa 3
    bb 2
    cc 3
    dd 3

    which is easy to achieve with a GROUP BY clause.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •