Sort data in excel using excel functions

**krishnapunekar** · 07-03-2010, 02:32 AM

Can you please let me know, how to sort data (in multiple columns across all rows) in excel 2003 using only excel functions (Not using any code or sort option in excel menu).

I am not sure how many rows can be present, as the data will be uploaded to the excel dynamically

Please see the attachment

**martindwilson** · 07-03-2010, 04:03 AM

now this depends on your error code which i assume you are sorting by.
if it contains text then this should work otherwise its slightly different for numbers
helper column sheet 2(note its an array formula), results sheet 3