+ Reply to Thread
Results 1 to 2 of 2

Google Sheets: need to dynamic formula for unique value and count multiple same value

  1. #1
    Registered User
    Join Date
    06-06-2014
    Location
    Nepal
    MS-Off Ver
    MS office professional 2016
    Posts
    90

    Google Sheets: need to dynamic formula for unique value and count multiple same value

    I M trying to do some atomization in google sheet with unique and count need help please..
    Attached Files Attached Files
    Last edited by wlinksanju; 11-20-2020 at 06:37 AM.

  2. #2
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Google Sheets: need to dynamic formula for unique value and count multiple same value

    This is one of those cases in which it'd be better to provide links to Google Sheets documents on Google Drive than attach an Excel workbook which others would then need to upload to Google Drive.

    For example, here's a link to the Google Sheets spreadsheet I created from your Excel workbook.

    If you need to pull distinct values from the USERNAME column in the raw worksheet with SOLVED DATE values between the dates in the summary worksheet, you should be able to use

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If you'd also need to filter USERNAME entries in col A if summary worksheet by SOLVED BY NAME entries in cols B to D, try

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    As for counts,

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    and use the custom number format 0;-0;;@ , which displays nothing for 0 values.
    Last edited by hrlngrv; 11-21-2020 at 10:35 PM. Reason: consistency

+ 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. Count Unique ID's across multiple sheets with multiple criteria
    By ccon1027 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2019, 02:51 AM
  2. Converting Unique,Filter,Countif formula in Google Sheets to Excel
    By imnotarobot in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-02-2019, 09:51 AM
  3. Count unique over multiple sheets.
    By gunnell in forum Excel General
    Replies: 4
    Last Post: 08-06-2018, 03:32 PM
  4. [SOLVED] Needing to count unique values across multiple sheets
    By TheTubaGeek in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 06-10-2014, 09:50 AM
  5. [SOLVED] count unique values across multiple sheets based on date
    By roninn75 in forum Excel General
    Replies: 8
    Last Post: 02-25-2014, 05:20 PM
  6. Replies: 8
    Last Post: 07-13-2012, 06:00 AM
  7. Count unique logs with multiple conditions of multiple sheets
    By Robert Bob in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-12-2007, 12:49 AM

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