From: Eric on
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
From: Eric on
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
From: Ms-Exl-Learner on
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
From: Eric on
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
From: Ms-Exl-Learner on
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