Hey guys, I did some searching and was able to come up with a formula that comes really close to what I need, but not exactly. I want to sort a list of data into alphabetical order using a formula. However, as shown in the attached file, cells that are not truly blank but that ="" are messing things up. Any help? Thanks!
alphabetizing.xlsx
In B2 Cell - Array Formula - Requires CTRL+SHIFT+ENTER
=IFERROR(INDEX($A$2:$A$34,MATCH(SMALL(COUNTIF($A$2:$A$34,"<="&$A$2:$A$34),SUMPRODUCT(--($A$2:$A$34=""))+ROWS($1:1)),COUNTIF($A$2:$A$34,"<="&$A$2:$A$34),0)),"")
Drag it down...
Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Another array-entered formula. A bit longer and counts on the input items to be one-of-a-kind.Formula:
Please Login or Register to view this content.
Dave
Excellent! Much thanks to both of you Sixthsense and FlameRetired, both work great! +1, +1. (now I will spend the rest of the day figuring out how these work haha......)
You're welcome. Thanks for the feedback and rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks