Sort Text LIst using formulae in Excel 2010

Posted on 2015-02-23
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.
Question by:satmisha
  • 3
  • 3
LVL 59

Expert Comment

by:Saurabh Singh Teotia
ID: 40627599
Attachment Missing??
LVL 25

Expert Comment

ID: 40627665
is this what u are looking for? please see example attached.

Author Comment

ID: 40627687
Hi Jim,  unable to open the attachment what is the ext ?
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.


Author Comment

ID: 40627695
Appreciate if you use index match rather lookup
LVL 25

Expert Comment

ID: 40627712

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

see attachment.
LVL 25

Accepted Solution

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

Author Closing Comment

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

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel Conditional Statements 11 40
Msbbox Notice (4 days) 27 59
Excel - conditional formatting on several columns 9 38
Time difference between dates without weekend 16 30
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
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 use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

822 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