Results 1 to 2 of 2

Subtracting 'no duplicates' from 'duplicates'

Threaded View

  1. #1
    Registered User
    Join Date
    05-22-2018
    Location
    Suffolk, England
    MS-Off Ver
    2013
    Posts
    1

    Smile Subtracting 'no duplicates' from 'duplicates'

    I am a New Member, so I would firstly like to say Hi to everyone ...

    HELP !! I have a list of mixed and reoccurring employees names in a rota list, they are all entered in one ROW E being E9:E194 ...

    In ROW 'B' B9:B194, I have set it so it show me if I have any duplicates, so in this ROW B it gives me the result of: no duplicates & duplicates ...
    What I am actually trying to do, is to have so that in a single cell lets say E1, that it returns a result by way of adding up and subtracting 'no duplicates & duplicates' show me the result by way of a number? ...

    * I hope I am explaining myself correctly ?

    Example: Lets say it works out that we have a total of 95 mixed and reoccurring employees names, and the total is 45 'no duplicates' & 40 'duplicates', I wont the Total to show in Cell E as 45 ...

    What a complete mess I am making of explaining myself, hopefully we have one of our team of members who can understand my "GodbleDeGoupe" and help me ?

    I can email my sheet to you if it would help with me explanation should you require it ...

    Thank you so much, even if all you can do is read this ...

    Kind regards, Alf
    Last edited by 6StringJazzer; 05-22-2018 at 02:09 PM. Reason: Moved from Hello..Introduce yourself

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Subtracting Duplicates
    By kiminai in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-08-2016, 05:10 AM
  2. Microsoft Excel - Subtracting Duplicates
    By kiminai in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 09-07-2016, 06:42 PM
  3. [SOLVED] Macro to find duplicates, concatenate cells, then delete old duplicates (2)
    By cny in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2016, 06:05 AM
  4. Macro to find duplicates, concatenate cells, then delete old duplicates
    By givemepuppies in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-04-2016, 02:43 AM
  5. [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
  6. Replies: 17
    Last Post: 07-05-2011, 05:37 PM
  7. Replies: 3
    Last Post: 03-09-2011, 07:00 PM

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