Thread: formula required to sort numbers as per given in sheet

Hello

Use Data->Sort->in ption 'Sort By' select Employee No. and also select option 'Ascending'

Thanks for reply but i want some function in excel which can do the task.. like if, avg etc. through which i can select the cells and do the same

Hello

U can split First field in your daily sheet using Delimit function or if Emplyee No. is of fixed width than using Left Function and then sort sheet

Hello

What do u mean by Function? u mean it should be done automatically? then u should record macro for the same

Thanks for reply but actually the things is that this sheet is generated from one of application but employee id is not getting shown according to acending format. so please give me any solution for the same.

Hello

If sheet is always in same formaat,then u can use macro by copying vb code from earlier file.

I do not have any sample code available from macro to sort data.. if you have an example then please give me so that i can check

Originally Posted by royUK

Try recording a macro to start with, see
http://www.excel-it.com/record_macro.htm

hello i have tried but it wont give me formula.. one of my friend suggested me to check formula from following site..

can anybody please try to give me formula using code from following link:

http://chandoo.org/wp/2008/10/22/sor...sing-formulas/

Originally Posted by vandanavai

Hello

If sheet is always in same formaat,then u can use macro by copying vb code from earlier file.

hello i have tried but it wont give me formula.. one of my friend suggested me to check formula from following site..

can anybody please try to give me formula using code from following link:

http://chandoo.org/wp/2008/10/22/sor...sing-formulas/

I think the problem might be that the sheet is protected(?)


If this is the case, the obvious solution is to ask the provider to remove the protection (or provide you with the password). The next-best is to copy the contents out to another sheet, but this is awkward.

Can you ask whoever makes the sheet to remove the protection or provide you with a password?

CC

Originally Posted by Cheeky Charlie

I think the problem might be that the sheet is protected(?)


If this is the case, the obvious solution is to ask the provider to remove the protection (or provide you with the password). The next-best is to copy the contents out to another sheet, but this is awkward.

Can you ask whoever makes the sheet to remove the protection or provide you with a password?

CC

Hello

Go through the attached sheet which is without password protection

That's great, so that's one problem out of the way!

Sorry kaustubhghag, why is it that you want to use a formula instead of just sorting the data with the 'A-Z' button?

CC

PS the array formula in the second attachment of your first post doesn't make sense...

Originally Posted by Cheeky Charlie

That's great, so that's one problem out of the way!

Sorry kaustubhghag, why is it that you want to use a formula instead of just sorting the data with the 'A-Z' button?

CC

PS the array formula in the second attachment of your first post doesn't make sense...

hello

Thanks for reply. Actual case is that this sheet is generated from one software and we want to write one formula based upon employee id that according to employee id whole sheet gets sorted out..

everytime we do not want to use excel asecending and descending btn.. instead we will just write formula so that it will sort data at runtime generattion of sheet