Forum Discussion
Name Order in Excel
I have a list of clay pigeon shooting scores containing several names with zero scores, as they haven't yet shot. There is also a placeholder in the form of a non-alphabetic character, , '/' , for a future member. The list is generated by '=INDEX(Surname,MATCH($S5,RankD,0),1) '. At present the names sort in reverse alphabetical order, preceded by the '/'. I want it to sort in alphabetical order followed by the '/'. How can I do this?
2 Replies
From your brief description, I, for one, was not able to get an image of the full workbook/spreadsheet you're working with. Perhaps some of the other folks around here can infer more of the database itself, from which your formula generates that reverse order.
That said, I think you would benefit from learning the SORT function. And, indeed, some other(s) of these Dynamic Array functions may be more what you need. FILTER is often very useful, for example -- it could easily screen out the "/" placeholder until such time as there's a name.
I did reply earlier. The solution offered didn'suit the problem because the list in question was generated by a formula, rather than being entered data. I solved it by inserting a minus in front of a PRODUCT function in the formula, which put everything in the right order.
Regards,
V Robinson
