loveguy1977
03-28-2012, 12:27 AM
Hello,
I'm looking for a formula that arrange column data into different rows based on the 1st letter.
Example:
Col (XX): content companies' name and I always insert new names.
Google
Boston Consulting Group
SAS Institute
Edward Jones
NetApp
Camden Property Trust
CHG Healthcare Services
DPR Construction
DreamWorks Animation
Chesapeake Energy
Robert W. Baird
Alston & Bird
Burns & McDonnell
Devon Energy
Bingham McCutchen
I need to list all company using formula to be listed and arranaged based on the 1st letter (A, B, C and so on)
In Col (A):
Alston & Bird
In Col (B):
Burns & McDonnell
Bingham McCutchen
In Col (C):
Camden Property Trust
CHG Healthcare Services
Chesapeake Energy
And so on.
In case I insert new company name in Col (XX) then it should be appear in related Col.
Thank you very much
I'm looking for a formula that arrange column data into different rows based on the 1st letter.
Example:
Col (XX): content companies' name and I always insert new names.
Boston Consulting Group
SAS Institute
Edward Jones
NetApp
Camden Property Trust
CHG Healthcare Services
DPR Construction
DreamWorks Animation
Chesapeake Energy
Robert W. Baird
Alston & Bird
Burns & McDonnell
Devon Energy
Bingham McCutchen
I need to list all company using formula to be listed and arranaged based on the 1st letter (A, B, C and so on)
In Col (A):
Alston & Bird
In Col (B):
Burns & McDonnell
Bingham McCutchen
In Col (C):
Camden Property Trust
CHG Healthcare Services
Chesapeake Energy
And so on.
In case I insert new company name in Col (XX) then it should be appear in related Col.
Thank you very much