LinkBack URL
About LinkBacks
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.
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.
Use a pivot table, as this is EXACTLY what they are meant to do. Just filter out (BLANK) and you get your desired result.
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.
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 *
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.
If you find it interesting, than use the option MikeTron showed you with a pivot table.
Thank you both. mikeTRON It was interesting the way you. Is there a formula method?
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks