Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort by specific word, then reg sort. (VB knowlege NEEDED)
Alright ladies and gents, I'm back. I am able to compile several worksheets into one, and then sort that data. Works perfectly. My "employer" now wants me to be able to put a specific word at the top of the sort, then regularly sort the rest of it. Want a better walkthrough of this? Okay, this deals with several attendance subsheets, that are compiled into one big workbook. the students all go to different schools. He wants a specific school to be put first; no matter what, then the rest of them just sorted normally. So, say the school he wants sorted first is "Garfunkle". All of the garfunkle students would be sorted first, then the rest of the schools/students would be sorted apart from them. How on earth would I do this?? -- Zlord ------------------------------------------------------------------------ Zlord's Profile: http://www.excelforum.com/member.php...o&userid=27519 View this thread: http://www.excelforum.com/showthread...hreadid=479329 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort by specific word, then reg sort. (VB knowlege NEEDED)
One way would be to use a helper column (No VB knowledge needed). Say
your school names are in column B. In an empty column in row 2 enter: =IF(B2="Garfunkle","AAAAAAA",B2) Copy down as needed and then sort by this new column. Hope this helps Rowan Zlord wrote: Alright ladies and gents, I'm back. I am able to compile several worksheets into one, and then sort that data. Works perfectly. My "employer" now wants me to be able to put a specific word at the top of the sort, then regularly sort the rest of it. Want a better walkthrough of this? Okay, this deals with several attendance subsheets, that are compiled into one big workbook. the students all go to different schools. He wants a specific school to be put first; no matter what, then the rest of them just sorted normally. So, say the school he wants sorted first is "Garfunkle". All of the garfunkle students would be sorted first, then the rest of the schools/students would be sorted apart from them. How on earth would I do this?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search/Sort Formula Help Needed | Excel Discussion (Misc queries) | |||
Search/Sort Formula Help Needed | Excel Discussion (Misc queries) | |||
Sort/Reference formula help needed. | Excel Discussion (Misc queries) | |||
Sort/Reference formula help needed. | Excel Discussion (Misc queries) | |||
sort data by specific word in cell? | Excel Discussion (Misc queries) |