Results 1 to 3 of 3

Unique name count with other lojick

Threaded View

  1. #1
    Registered User
    Join Date
    11-28-2014
    Location
    india
    MS-Off Ver
    7
    Posts
    141

    Unique name count with other lojick

    In my attached workbook I have a data from that I just want to calculate the Unique name count
    1) how many Analyst processing “ENG “ as “Process, when “Successful/Rejected”=” Successful”, “Start/Close”=”Closed”,” Region”=”JAPAC”.
    2) how many Analyst processing “Indirect “ as “Process, when “Successful/Rejected”=” Successful”, “Start/Close”=”Closed”,” Region”=”AMER”.

    The only problem what I am facing here is it’s calculate the total number of Analyst but I want the unique name count,

    if you go through the attachment you can fined for each name different deal ID will be there, if you filter out as I mention,it will reflect deal ID as 9,18,34,43, under "DIN name

    I have putted my formula in H10 and K10.in both the scenario the result is reflecting as 4 (count of all name) but the correct one will be 1 as the same name is reflecting as 4 times.

    Can any one help me out in this by any formula?

    Regards
    Arindam
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sort and Count Unique List Across Multiple Columns - Student Count
    By BuntyMac in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 08-17-2014, 07:00 AM
  2. [SOLVED] Unique Total Value Count per Unique Lookup Values
    By KnightVision in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-02-2014, 05:03 AM
  3. [SOLVED] Count unique entries based off unique criteria in another column
    By hambly in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-11-2014, 03:33 PM
  4. [SOLVED] How To Count Unique Values in COL A Subject for each unique value in COL B ??
    By amirtehrani in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-06-2012, 03:00 AM
  5. [SOLVED] changing a current mod (count unique visible cells ->count unique visible cells criteria
    By liranbo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-30-2012, 03:58 AM
  6. Replies: 0
    Last Post: 03-22-2012, 08:44 PM
  7. Replies: 17
    Last Post: 08-24-2009, 08:58 AM

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