+ Reply to Thread
Results 1 to 2 of 2

Finding/Counting unique values over multiple tabs

  1. #1
    Registered User
    Join Date
    11-06-2017
    Location
    Bellevue, WA
    MS-Off Ver
    2010
    Posts
    1

    Finding/Counting unique values over multiple tabs

    Seems so simple but I can't get there...

    In Sheet1 I have people and amounts:
    Capture.PNG
    In Sheet2 I have other people and amounts:
    Capture2.PNG
    In Sheet3 I need to consolidate them:
    Capture3.PNG

    For my project, awards, people may have received multiple awards but it's important that I don't count them multiple times. SUMIF is certainly easy enough for the amounts (Randy has 300), but I need the Count of each person to be only 1 (unique)... COUNTIF can't do it. We can obviously do this with the extra steps of combining all the names from the different sheets > removing duplicates > pasting the resulting unique list somewhere and summing off that, but I want to specifically avoid that sequence.

    I've tried wrapping FREQUENCY and other things around my CountIF, but the multiple tabs has me stumped. What do you think?
    Thanks

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Finding/Counting unique values over multiple tabs

    Attach a sample workbook (not a picture!). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

+ 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. Counting Unique values with multiple criteria
    By qussai in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-10-2017, 07:10 AM
  2. Counting Unique Values on Multiple Criteria
    By buhwheet in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-10-2014, 01:32 AM
  3. [SOLVED] Counting unique values from data on TWO separate excel tabs
    By rshukla in forum Excel General
    Replies: 2
    Last Post: 05-06-2013, 02:08 AM
  4. [SOLVED] Counting unique values from data on TWO separate excel tabs
    By rshukla in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-05-2013, 05:22 PM
  5. Replies: 0
    Last Post: 05-05-2013, 05:47 AM
  6. [SOLVED] Counting Unique Values with Multiple Criteria
    By smwbuddy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-15-2013, 08:35 PM
  7. Finding and returning multiple values in colomns across two tabs.
    By leaveit2bevo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-01-2013, 01:21 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