Solved

Sort Text LIst using formulae in Excel 2010

Posted on 2015-02-23
7
28 Views
Last Modified: 2015-03-14
Hi Team,

I want to sort list in ascending orders using formulae. Attaching the list for your reference.

Do not want to use array formulae though.

Looking forward to hearing from you.
0
Comment
Question by:satmisha
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 59

Expert Comment

by:Saurabh Singh Teotia
ID: 40627599
Attachment Missing??
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 40627665
is this what u are looking for? please see example attached.
Sorting-a-List-Alphabetically-Without-Fi
0
 

Author Comment

by:satmisha
ID: 40627687
Hi Jim,  unable to open the attachment what is the ext ?
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 

Author Comment

by:satmisha
ID: 40627695
Appreciate if you use index match rather lookup
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 40627712
Satmisha,

Lookup function is good, it does not require the special keystroke of Control Shift Enter

see attachment.
EE.xlsx
0
 
LVL 26

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40627713
if you insist on index and match, then you require the control shift enter keystroke.  see attached formula with index and match
SORT.xlsx
0
 

Author Closing Comment

by:satmisha
ID: 40665238
Apologies for my late reply.Highly appreciate your quick reply Pal. TC
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question