satmisha
asked on
Sort Text LIst using formulae in Excel 2010
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.
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.
Attachment Missing??
is this what u are looking for? please see example attached.
Sorting-a-List-Alphabetically-Without-Fi
Sorting-a-List-Alphabetically-Without-Fi
ASKER
Hi Jim, unable to open the attachment what is the ext ?
ASKER
Appreciate if you use index match rather lookup
Satmisha,
Lookup function is good, it does not require the special keystroke of Control Shift Enter
see attachment.
EE.xlsx
Lookup function is good, it does not require the special keystroke of Control Shift Enter
see attachment.
EE.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Apologies for my late reply.Highly appreciate your quick reply Pal. TC