Solved

Sort Text LIst using formulae in Excel 2010

Posted on 2015-02-23
7
23 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
  • 3
  • 3
7 Comments
 
LVL 59

Expert Comment

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

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

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

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 25

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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;…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now