+ Reply to Thread
Results 1 to 2 of 2

How do I retain duplicates and discount unique entries?

  1. #1
    Registered User
    Join Date
    12-01-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    1

    How do I retain duplicates and discount unique entries?

    I have a list of customers who signed up for a free month. Some went on to pay for the second month and so appear twice because both the first free month and the second paid month are displayed. I'm trying to answer a question from Marketing: How many of those who signed up for the offer went on to pay for a month?

    For example:

    Customer 1 Paid £0
    Customer 2 Paid £0
    Customer 2 Paid £10
    Customer 3 Paid £0
    Customer 4 Paid £0
    Customer 4 Paid £10
    Customer 5 Paid £0

    While what I want to get to is:

    Customer 2 Paid £0
    Customer 2 Paid £10
    Customer 4 Paid £0
    Customer 4 Paid £10

    While I'm familliar with VLOOKUP and pivot tables, I haven't used macros. Is there anyone who can help?

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: How do I retain duplicates and discount unique entries?

    Suggest using a countif function to identify the customers which appear twice and then filter.

    =COUNTIF(A:A,A1)

    in Cell C1 and copy down - assuming data is in A & B with no header

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to find duplicates, concatenate Unique Values, then delete old duplicates
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2013, 04:32 PM
  2. Replies: 5
    Last Post: 02-21-2013, 11:37 AM
  3. [SOLVED] Need to merge duplicates in ColumnA, delete entries in ColumnB but keep unique in C
    By mdhillyer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-06-2012, 03:10 AM
  4. How can I retain text box entries on a user form after saving and reopening?
    By rkjudy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-20-2011, 12:17 AM
  5. sort and remove duplicates macro causing unique entries to vanish
    By excellentexcel in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-24-2009, 04:58 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1