+ Reply to Thread
Results 1 to 9 of 9

Formula for getting all names just once wether they are duplicate of unique

Hybrid View

  1. 06-09-2023, 05:12 AM #1
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Formula for getting all names just once wether they are duplicate of unique

    Your sample file FAR EXCEEDS our suggestion (10-20 rows data) and I really do not know what you expect to see and where you expect to see it.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  2. 06-09-2023, 07:15 AM #2
    jibranchohan
    jibranchohan is offline
    Registered User
    Join Date
    08-31-2021
    Location
    pakistan
    MS-Off Ver
    2019
    Posts
    6

    Post Re: Formula for getting all names just once wether they are duplicate of unique

    hi, I want to populate all unique rows in sheet2 from sheet1. all unique rows + duplicates at 1 time.

    please find attached the Excel.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to Show wether figures are up or down
    By m_789 in forum Excel General
    Replies: 2
    Last Post: 04-27-2023, 07:13 AM
  2. How to assign unique ID to duplicate names or numbers within a list
    By Ksingh6 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-20-2019, 08:31 PM
  3. Double data validation list containing duplicate names to display unique names on dropdown
    By danwoltrs in forum Excel General
    Replies: 7
    Last Post: 12-23-2015, 07:43 AM
  4. Need a formula to create a unique identifier for Duplicate names
    By asharma9 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-21-2015, 04:37 PM
  5. remove duplicate names from different sheets and past only unique names in another sheet
    By aleanboy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2014, 09:44 AM
  6. duplicate names with unique data - how to combine?
    By hwishman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2014, 02:39 PM
  7. List of unique and duplicate names that correspond with dates
    By corbintx in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2012, 01:24 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1