C
Clueless in Seattle
I use an Excel 2003 worksheet for storing the results of my medical lab
results.
One of the columns is labled "Component" and contains the names of the
tests.
I have formatted the cells in this column as text.
I also have a column for the dates of the tests.
When I try to sort by Component, the rows don't end up in alphabetical
order.
Rows 2-13 are sorted alphabetically from CORTISOL to SODIUM
And then it starts over and rows 14-70 are sorted alphabetically
ADDITIONAL FINDINGS to VITD-25 OH
I'd be grateful for some ideas on how to troubleshoot and solve this
problem.
results.
One of the columns is labled "Component" and contains the names of the
tests.
I have formatted the cells in this column as text.
I also have a column for the dates of the tests.
When I try to sort by Component, the rows don't end up in alphabetical
order.
Rows 2-13 are sorted alphabetically from CORTISOL to SODIUM
And then it starts over and rows 14-70 are sorted alphabetically
ADDITIONAL FINDINGS to VITD-25 OH
I'd be grateful for some ideas on how to troubleshoot and solve this
problem.