+ Reply to Thread
Results 1 to 5 of 5

Sort by helper column even if values in helper are alike

  1. #1
    Registered User
    Join Date
    08-09-2016
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    20

    Sort by helper column even if values in helper are alike

    Im sorting everything between 0 and 90 from UD to IN,

    But it doesn't seem to be able to handle if there are more of one value... how do I?

    Thanks!

    http://www.excelforum.com/attachment...1&d=1470814106
    Attached Files Attached Files

  2. #2
    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
    79,374

    Re: Sort by helper column even if values in helper are alike

    How do you want it to handle duplicates?
    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.

  3. #3
    Registered User
    Join Date
    08-09-2016
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    20

    Re: Sort by helper column even if values in helper are alike

    Quote Originally Posted by AliGW View Post
    How do you want it to handle duplicates?
    Don't care about the order, I just need all duplicates to show. I can have more then one item on that day, and I need to know about them all - not just one of the items.

  4. #4
    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
    79,374

    Re: Sort by helper column even if values in helper are alike

    I'm not clear what you are trying to achieve. Apart from the missing item, the two sheets seem to contain the same data in the same order. What am I missing?

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Sort by helper column even if values in helper are alike

    Try

    in A4

    =IFERROR(INDEX(UD!A$3:A$100,SMALL(IF((UD!$G$2:$G$100>0)*(UD!$G$2:$G$100<=90),ROW($A$2:$A$100)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")

    Enter with Ctrl+Shift+Enter

    Copy across and down

+ 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. Helper column to only show name
    By zplugger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2015, 08:52 AM
  2. Need help with helper column results
    By ksliger in forum Excel General
    Replies: 6
    Last Post: 02-19-2014, 05:34 PM
  3. Helper Column Won't Filter
    By Gard5096 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2014, 04:46 PM
  4. [SOLVED] Helper Column IF Statement!
    By pwall1115 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-13-2013, 12:41 AM
  5. [SOLVED] help creating helper column
    By Allen Clark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2006, 12:20 AM
  6. [SOLVED] Changing the Helper Column
    By apples72 in forum Excel General
    Replies: 11
    Last Post: 11-13-2005, 06:22 PM
  7. [SOLVED] What is a helper column?
    By RMPPOD in forum Excel General
    Replies: 3
    Last Post: 01-28-2005, 04:06 PM

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