+ Reply to Thread
Results 1 to 4 of 4

Group by multiple criteria - Unique values

  1. #1
    Registered User
    Join Date
    04-18-2023
    Location
    Canada
    MS-Off Ver
    365
    Posts
    10

    Group by multiple criteria - Unique values

    Hello! Need a formula in Column E. If the same "Route" (Column B") is worked by different names in the same Department (Column C) , then mark as Multiple in Column E.
    If the same "Route" is worked by the same name in the same department, then mark with the Name in Column E.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Group by multiple criteria - Unique values

    In F2 copied down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  3. #3
    Registered User
    Join Date
    04-18-2023
    Location
    Canada
    MS-Off Ver
    365
    Posts
    10

    Re: Group by multiple criteria - Unique values

    Worked perfectly! Thanks!

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Group by multiple criteria - Unique values

    Thanks for feed back.

+ 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. vba code to split unique values from multiple repeating group
    By crusadessword in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-27-2023, 06:38 PM
  2. sum unique values with multiple criteria
    By tahas in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-17-2017, 02:03 AM
  3. Extract data from multiple columns, group and sum up unique values
    By Alcotraz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2015, 06:54 PM
  4. [SOLVED] Sum unique values with multiple criteria
    By Billaus in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 10-11-2014, 10:48 PM
  5. group unique values on multiple colums
    By sharmaremuk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-21-2011, 03:10 AM
  6. Macro to remove duplicates values and keep unique values bases on multiple criteria
    By Ricker090 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2011, 04:37 PM
  7. Finding top 2 values per group based on multiple criteria
    By schuc in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-22-2007, 10:51 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