View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MS-Exl-Learner MS-Exl-Learner is offline
external usenet poster
 
Posts: 132
Default How to sort names in alphabetical ascending order?

Large and Small functions only work with the Numbers and it doesn't work with
Text Characters.

--------------------
(Ms-Exl-Learner)
--------------------


"Eric" wrote:

N.B. how can I sort them using formula, such as large or small function
Thanks in advance for any suggestions
Eric

"Eric" wrote:

There is a table from cell M2 to W200, which contains names and empty cell.
I would like to retrieve the names and sort them in in alphabetical
ascending order under Z column.
Does anyone have any suggestions on how to do it in excel?
Thanks in advance for any suggestions
Eric