Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I sort a group of calculated cells in Excel?
I've created a spreadsheet that I copy and paste information with people's
last name and first name. I've created a table where I've recreated the list so they are first name, space and then last name. I need to sort the table into alphabetical order based on the first name. Using the Sort function doesn't change the order from what they what they were first created. What I'd like to do is build a function into the spreadsheet so that the table is automatically sorted after I copy and paste the list into the worksheet. Is this possible and can you show me how to do it? |
#2
|
|||
|
|||
Is this what you're looking for? The Input list is placed in column A2. =INDEX(List,MATCH(SMALL(COUNTIF(List,"<="&List),RO WS(A2:$A$2)),COUNTIF(List,"<="&List),0)) I have defined a name (Menu:InsertNameDefine...) List: =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A$2:$A$1000 0)) Attached zip-file: http://www.excelforum.com/attachment...tid=3565&stc=1 Ola Sandström +-------------------------------------------------------------------+ |Filename: Book5.zip | |Download: http://www.excelforum.com/attachment.php?postid=3565 | +-------------------------------------------------------------------+ -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=384453 |
#3
|
|||
|
|||
This solution is PERFECT! Not only does it solve the problem, it also
includes information that let me include the formula in my own spreadsheet! Thank you very much! "olasa" wrote: Is this what you're looking for? The Input list is placed in column A2. =INDEX(List,MATCH(SMALL(COUNTIF(List,"<="&List),RO WS(A2:$A$2)),COUNTIF(List,"<="&List),0)) I have defined a name (Menu:InsertNameDefine...) List: =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A$2:$A$1000 0)) Attached zip-file: http://www.excelforum.com/attachment...tid=3565&stc=1 Ola Sandström +-------------------------------------------------------------------+ |Filename: Book5.zip | |Download: http://www.excelforum.com/attachment.php?postid=3565 | +-------------------------------------------------------------------+ -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=384453 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel subtotal group sort | Excel Worksheet Functions | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions | |||
HELP: Access table linked to Excel - calculated fields? | Excel Worksheet Functions |