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
|