Closed Thread
Results 1 to 3 of 3

Counting unique values from data on TWO separate excel tabs

  1. #1
    Registered User
    Join Date
    06-10-2009
    Location
    Austin, TX
    MS-Off Ver
    Professional Plus 2010
    Posts
    21

    Counting unique values from data on TWO separate excel tabs

    Hi everyone,

    In the attached file, the problem is listed on Tab 1.

    I just need to find a way to count unique values but using a formula that would look up data in both tabs at the same time. The correct answer is provided in Tab 1. Can someone enter the required formula in the two highlighted yellow cells?

    Thanks!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-10-2009
    Location
    Austin, TX
    MS-Off Ver
    Professional Plus 2010
    Posts
    21

    Re: Counting unique values from data on TWO separate excel tabs

    This issue was solved by forum members "Harribone" and "Lemice" in the Excel Formulas and Functions forum, so I'm marking this thread as solved. Link to the thread with solution is listed below:

    http://www.excelforum.com/excel-form...xcel-tabs.html


    As always, thanks to all the contributors for their expert assistance!

  3. #3
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,160

    Re: Counting unique values from data on TWO separate excel tabs

    Rshukla,

    For further reference, please remember that its against forum rules to open a duplicate thread. You are duplicating efforts. If you have not received a reply, you can bump your thread.

    Thread duplicate, hence closed.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

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