Forum Discussion
nicole82
Mar 22, 2023Copper Contributor
Excel custom aphlabetical sort not working properly
I'm trying to sort a big list of names first by last name, then by first name. I'm finding that some of the sort is not accurate. I colored the cells only for easier viewing of the inaccurate sort. I have tried over and over, and different ways. I need some help!
The attached workbook is a re-creation of the sort issue you have in your workbook. There's also a LEN example.
- HecatonchireIron Contributor
Hello
If last name is in column A
In an empty cell put this formula
=A173 = A174 (compare the yellow cells to the white)
The result must be true
- nicole82Copper ContributorIt comes back as false.
- HecatonchireIron Contributor
- Patrick2788Silver Contributor
There may be leading or trailing spaces in the First Name and/or Last Name columns.
- nicole82Copper Contributor
- Patrick2788 we checked for spaces & made sure nothing was "hidden"
- Detlef_LewinSilver Contributor