Sort list, but only certain values

[roelandwatteeuw]

Hi

I have a Custom List added to my Sort options.
This contains 10 names of people that need to be at the top of the list. (Person A - Person J)
That works fine with the list.

BUT...

The table contains also other names. (Person K - ...)
And I don't want them to be sorted alphabetically - just keep them where they are.

Is that possible?

thx
Roeland

 

[oldbrewer]

				george harry julian must stay where they are
				the rest must be sorted alphabetically											a	1
									FIXED									b	2
bill		4							george					original order			c	3
basil		5							harry									d	4
george	FIXED	1005	6						julian					bill				e	5
charlie		7												alf				f	6
dave		8												george				g	7
harry	FIXED	1008	9											charlie				h	8
julian	FIXED	1009	10											dave				I	9
fred		11												harry				j	10
ed		12												julian				k	11
														fred				l	12
COLA	COLB	COLC	COLD	COLE	COLF	COLG	COLH	COLI	COLJ	COLK	COLM	COLN		ed	COLP	COLQ		m	COLT
							2	3	4	5								n	14
			1	4	bill	2	9	12	12	0	210320	203002	basil	4	4			o	15
			2	5	basil	2	1	19	9	12	203002	210320	bill	5	5			p	16
			3	7	charlie	3	8	1	18	12	308292	308292	charlie	7	7			q	17
			4	8	dave	4	1	22	5	0	403250	403250	dave	8	8			r	18
			5	11	fred	6	18	5	4	0	618540	504000	ed	11	11			s	19
			6	12	ed	5	4	0	0	0	504000	618540	fred	12	12			t	20
			7	1005	george	7	5	15	18	7	706687	706687	george	1005	6			u	21
			8	1008	harry	8	1	18	18	25	803005	803005	harry	1008	9			v	22
			9	1009	julian	10	21	12	9	1	1022291	1022291	julian	1009	10			w	23
																		x	24
																		y	25
																		z	26
									1	4	basil
									2	5	bill
									3	6	george
									4	7	charlie
									5	8	dave
									6	9	harry
									7	10	julian
									8	11	ed
									9	12	fred
				by using MANY helper stages I produced what you want
				in fairness all these helpers could be hidden way over to the right
				a list of names to be fixed is used to mark the fixed names in column B
				the names are then given their row number with 999 added to fixed names
				these are listed in ascending order in column E
				weith the associated name in column F
				each letter in the name is given a number from the table in column S
				column M is the totals in ascending order
				column N is the new name order
				column O is column C in ascending order
				column P merely re converts the 999+ numbers to their original order
				the last lower table is column P in ascending order with the name associated in col M
				PHEW

<colgroup><col span="3"><col><col span="18"></colgroup><tbody>
</tbody>

 

[roelandwatteeuw]

Wow, thanks!

Meanwhile, I also found a solution with a few helper columns. I think it's the only possibility...
Maybe Excel should integrate a STOP in the sorting option like they have in the Conditional Formating.

Oh well, it keeps us busy