I
iwtci
Good day everyone,
in this list, i learned that that there is no such thing described a
impossible since i see new propblems solved everyday, i hope you ar
ready for a new challenge i.e. at least it is to me.
i have a list of names in A1:A50. the name could be more than one wor
length i.e. have spaces. we have a limit of text length to be 3
characters. the list may have duplicate entries. the names are entere
in random order and they are not case sensetive, hence, the origina
name list is not sorted. i wish to extract a list of the unique name
from the original list is column A and then, have the extracted lis
sorted out in either ascending or descending order. both of origina
name list and sorted names are on the same worksheet. the sorted name
shall be in column D1 upto D????
i wish to sort these names either ascending or descending order usin
the following manner: -
- find the number of the unique names in range A1:A50 and store it i
cell B1, name this cell as n
- write a formula that extracts unique names in the original list an
place it in range C1:C(1+n) to avoide getting any error message on th
screen. now, this range has a list of unique names, however, no
necessarily sorted.
- in range D1
(1+n) i need to sort out the names listed in the rang
C1:C(1+n). one way i think, shall run as follows: -
- find the max name in the range C1:C(1+n) and place it in D1.
- define a dynamic range that will have the entries of C1:C(1+n) les
the name previously entered in D1, then, find the max. name in thi
dynamic range and place it in D2, repeat the process until we are lef
with the minimum value in this range which shall be in cell D(1+n).
what do you think?!
is this really possible,
TIA
Khaldou
in this list, i learned that that there is no such thing described a
impossible since i see new propblems solved everyday, i hope you ar
ready for a new challenge i.e. at least it is to me.
i have a list of names in A1:A50. the name could be more than one wor
length i.e. have spaces. we have a limit of text length to be 3
characters. the list may have duplicate entries. the names are entere
in random order and they are not case sensetive, hence, the origina
name list is not sorted. i wish to extract a list of the unique name
from the original list is column A and then, have the extracted lis
sorted out in either ascending or descending order. both of origina
name list and sorted names are on the same worksheet. the sorted name
shall be in column D1 upto D????
i wish to sort these names either ascending or descending order usin
the following manner: -
- find the number of the unique names in range A1:A50 and store it i
cell B1, name this cell as n
- write a formula that extracts unique names in the original list an
place it in range C1:C(1+n) to avoide getting any error message on th
screen. now, this range has a list of unique names, however, no
necessarily sorted.
- in range D1
(1+n) i need to sort out the names listed in the rangC1:C(1+n). one way i think, shall run as follows: -
- find the max name in the range C1:C(1+n) and place it in D1.
- define a dynamic range that will have the entries of C1:C(1+n) les
the name previously entered in D1, then, find the max. name in thi
dynamic range and place it in D2, repeat the process until we are lef
with the minimum value in this range which shall be in cell D(1+n).
what do you think?!
is this really possible,
TIA
Khaldou