+ Reply to Thread
Results 1 to 5 of 5

how to Making list by the same name ?

  1. #1
    Registered User
    Join Date
    11-18-2015
    Location
    qatar
    MS-Off Ver
    2010
    Posts
    61

    how to Making list by the same name ?

    hi dear friends,

    I have a list of similar names and Contains several empty rows.Now I want to Sortable by name
    Ignoring empty rows.
    For more explanation, see the sample files.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: how to Making list by the same name ?

    Use a pivot table, as this is EXACTLY what they are meant to do. Just filter out (BLANK) and you get your desired result.
    Attached Files Attached Files
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: how to Making list by the same name ?

    In Cell E4

    =IF(ROWS($A$1:$A1)>COUNTIF($A$4:$A$18,"<>"),"",INDEX(A$4:A$18,SMALL(INDEX(($A$4:$A$18<>"")*(ROW($A$4:$A$18)-ROW($A$4)+1),),COUNTBLANK($A$4:$A$18)+ROWS($A$1:$A1))))


    Copy down and across
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Registered User
    Join Date
    11-18-2015
    Location
    qatar
    MS-Off Ver
    2010
    Posts
    61

    Re: how to Making list by the same name ?

    Thank you both. mikeTRON It was interesting the way you. Is there a formula method?
    Dear friend Ace_XL writing a formula that only Ignoring empty rows And based on what I have described do not work.
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,964

    Re: how to Making list by the same name ?

    Please Login or Register  to view this content.
    If you find it interesting, than use the option MikeTron showed you with a pivot table.

    a pivot table is a built in solution in Excel, which expands in every new version of Excel.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. [SOLVED] making dropdown list wider without making cell wider ???
    By wayneg in forum Excel General
    Replies: 16
    Last Post: 05-20-2021, 12:53 AM
  2. Replies: 4
    Last Post: 07-07-2015, 10:30 AM
  3. Taking a list, and Making another list
    By cdeguzman in forum Excel General
    Replies: 6
    Last Post: 03-23-2015, 04:11 PM
  4. Making a List of Objects Based off Another List
    By Codeman553 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2013, 11:02 AM
  5. Making a top ten list?
    By jadkins1019 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2011, 04:55 PM
  6. Making a List
    By ChrisKader in forum Excel General
    Replies: 10
    Last Post: 10-13-2010, 11:03 PM
  7. Making a new list
    By cityfc in forum Excel General
    Replies: 3
    Last Post: 11-13-2005, 09:00 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