View Single Post
  #5   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?

Assume that you are having the below data like the below:-

Row / Col A Column
Row1 NAME
Row2 NDF
Row3 ABC
Row4 YJK
Row5 LDF
Row6 NTK
Row7 PMR
Row8 OTF
Row9 KQY
Row10 DFT
Row11 PKR

In B2 cell paste the below formula
=COUNTIF($A$2:$A$11,"<="&$A2)
Copy the B2 cell and paste it upto B11.

In C2 cell paste the below formula
=INDEX($A$2:$A$11,MATCH(ROW()-ROW($C$1),$B$2:$B$11,FALSE))
Copy the C2 cell and paste it upto C11.

Now the data will look like the below

Row / Col A Column B Column C Column
Row1 NAME NUMBER RESULT TEXT
Row2 NDF 5 ABC
Row3 ABC 1 DFT
Row4 YJK 10 KQY
Row5 LDF 4 LDF
Row6 NTK 6 NDF
Row7 PMR 9 NTK
Row8 OTF 7 OTF
Row9 KQY 3 PKR
Row10 DFT 2 PMR
Row11 PKR 8 YJK

Hope this is what you are expecting to do€¦

Remember to Click Yes, if this post helps!

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


"Eric" wrote:

Do you have any suggestions on what kind of functions work with text
characters?
Thanks in advance for any suggestions
Eric

"Ms-Exl-Learner" wrote:

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