+ Reply to Thread
Results 1 to 9 of 9

Sort entries per column, unique values on top

  1. 01-18-2021, 02:40 AM #1
    Rianne
    Rianne is offline
    Registered User
    Join Date
    06-07-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    32

    Question Sort entries per column, unique values on top

    Hi,

    Would like to seek help please on the attached file. Is it possible to sort columns B, D, F, and H under sheet "2. Remove common words", with the crossed out list at the bottom?
    Can the same rule be applied to sheet "3. Challenge_Scores"?

    Thank you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-18-2021, 02:50 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,434

    Re: Sort entries per column, unique values on top

    You will need VBA to do this - shall I move the thread for you?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 01-18-2021, 04:06 AM #3
    Rianne
    Rianne is offline
    Registered User
    Join Date
    06-07-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    32

    Re: Sort entries per column, unique values on top

    I see. Yes please, if not possible without macro. Thank you.
    Rianne ^^
    Reply With QuoteRegister To Reply
  4. 01-18-2021, 04:46 AM #4
    soledad
    soledad is offline
    Forum Contributor
    Join Date
    11-21-2013
    Location
    zimbabwe
    MS-Off Ver
    Excel 2003
    Posts
    124

    Re: Sort entries per column, unique values on top

    Could you give me a description about your final result? How does it look like?
    Reply With QuoteRegister To Reply
  5. 01-18-2021, 05:27 AM #5
    Rianne
    Rianne is offline
    Registered User
    Join Date
    06-07-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    32

    Re: Sort entries per column, unique values on top

    For example under Team C column (sheets 2. Remove common words and 3. Challenge_Scores), entries would be like this:

    COSIED
    DERRIES
    BERRIES (crossed out)
    CERISE (crossed out)
    COPIED (crossed out)
    COPIER (crossed out)
    COPIERS (crossed out)
    COPIES (crossed out)
    COSIER (crossed out)
    DESERT (crossed out)
    DESIRE (crossed out)
    DESIRED (crossed out)
    DESIRER (crossed out)
    DRIEST (crossed out)
    POISED (crossed out)
    POSTER (crossed out)
    RECOPIES (crossed out)
    REUSED (crossed out)
    TERRIER (crossed out)
    COSTER (crossed out)

    So the words not crossed out will be listed above those crossed out words.

    Thanks!
    Reply With QuoteRegister To Reply
  6. 01-18-2021, 06:11 AM #6
    mohadin
    mohadin is offline
    Valued Forum Contributor
    Join Date
    06-27-2010
    Location
    sYRIA
    MS-Off Ver
    Excel 2013
    Posts
    669

    Re: Sort entries per column, unique values on top

    Hi may be
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 01-18-2021, 09:24 PM #7
    Rianne
    Rianne is offline
    Registered User
    Join Date
    06-07-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    32

    Re: Sort entries per column, unique values on top

    Hi Mohadin!!! Thanks it worked!!!! Can we add a rule to sort the words not crossed out??
    Attached Files Attached Files
    Last edited by Rianne; 01-18-2021 at 09:27 PM.
    Reply With QuoteRegister To Reply
  8. 01-18-2021, 10:39 PM #8
    soledad
    soledad is offline
    Forum Contributor
    Join Date
    11-21-2013
    Location
    zimbabwe
    MS-Off Ver
    Excel 2003
    Posts
    124

    Re: Sort entries per column, unique values on top

    Another way with array functions in sheet "2. Remove common words"
    B3:
    Please Login or Register  to view this content.
    D3:
    Please Login or Register  to view this content.
    F3:
    Please Login or Register  to view this content.
    H3:
    Please Login or Register  to view this content.
    Confirm with Ctrl+Shift+Enter then fill down
    Similarily to sheet "3. Challenge_Scores"
    Reply With QuoteRegister To Reply
  9. 01-18-2021, 11:45 PM #9
    Rianne
    Rianne is offline
    Registered User
    Join Date
    06-07-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    32

    Re: Sort entries per column, unique values on top

    Wow, that worked, too!!! I guess I'd use this one to use my sheet without additional macro. I'm not sure if sorting of the non crossed out entries worked here, let me try with my other sheets. Thank you.
    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. Extract filter, sort, count a unique distinct values from filtered list in Column A.
    By Mohammad Munawar in forum Excel General
    Replies: 2
    Last Post: 11-23-2020, 12:03 PM
  2. Sort unique values in column while ignoring empty/blank cells
    By mainemojo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-15-2019, 04:02 PM
  3. Need unique Values from a single column, rows contain multiple entries
    By ADEXL in forum Excel General
    Replies: 2
    Last Post: 05-05-2017, 03:31 AM
  4. [SOLVED] How do I sort and extract unique entries from multiple references
    By sherlock99 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2014, 08:01 AM
  5. Using IF to sort unique entries
    By moonsong40 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-23-2012, 04:13 PM
  6. [SOLVED] Second column of unique drop down list entires not recognizing all unique entries
    By ObiWanBaloney in forum Excel General
    Replies: 7
    Last Post: 05-11-2012, 02:00 PM
  7. Counting unique entries in column A but only if specific values appear in columns B and C
    By markx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2005, 10:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1