Forum Discussion
Name Order in Excel
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.
- BrumasNov 30, 2025Copper Contributor
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