Sorting from the lowest to highest value

[aveternik]

Hi,
please take a look to file attached. I am using INDIRECT function to get the data from each workbook to overview spreadsheet. That parts works fine.
The problem happens when I want to sort by filtering from the lowest to highest value (lets say for an instance for column ANNUAL COST SAVING). It is simply not done.

Can someone help me finding the solution for this problem?

Thanks a lot,
Andrej

sorting_doest_work.xlsm
	B	C	D	E			H	I	J				N																	AE	AF	AG
10	Link	Nr	PROJECT DESCRIPTION	N			PHASE	PROGRESS	B				REDUCTION																	LAST ACTIVITY DATE	LAST ACTIVITY	PLANNED SOP
11	1	(1)	AAAAAAAAAAA	N4			4	OPEN SPD TASK					- 194.325 €																	15.04.24	DO NOT DELETE	MARCH
12	2	(2)	BBBBBBBBBBBBBBBBB	N4			4	OPEN R&D TASK					- 435.698 €																	19.02.24	DO NOT DELETE	MARCH
13	3	(3)	CCCCCCCCCCCCCCCCCCCCCCC	N4			4	OPEN SPD TASK					- 201.064 €																	19.02.24	DO NOT DELETE	MARCH
14	4	(4)	DDDDDDDDDDDDDDDDD	N3			1	ON TRACK					- 35.400 €																	Y: DATE:	DDDDDDDDDDDDDDDDD
15	5	(5)	EEEEEEEEEEEEEEEEEEEEE	N1			5	FINISHED					- 616.400 €																	Y: DATE:	EEEEEEEEEEEEEEEEEEEEE
CFT

Cell Formulas
Range	Formula
B11:B15	B11	=INDIRECT("'"&C11&"'"&"!"&"A1")
C11:C15	C11	=" ("&ROW()-10&")"
D11:D15	D11	=IFERROR(IF(INDIRECT("'"&C11&"'"&"!"&"C7")=0,"",INDIRECT("'"&C11&"'"&"!"&"c7")),"")
E11:E15	E11	=IFERROR(IF(INDIRECT("'"&C11&"'"&"!"&"c9")=0,"",INDIRECT("'"&C11&"'"&"!"&"c9")),"")
H11:H15	H11	=IFERROR(IF(INDIRECT("'"&C11&"'"&"!"&"C12")=0,"",INDIRECT("'"&C11&"'"&"!"&"C12")),"")
I11:I15	I11	=IFERROR(IF(INDIRECT("'"&C11&"'"&"!"&"C13")=0,"",INDIRECT("'"&C11&"'"&"!"&"C13")),"")
N11:N15	N11	=IFERROR(IF(INDIRECT("'"&C11&"'"&"!"&"C27")=0,"",INDIRECT("'"&C11&"'"&"!"&"C27")),"")
AE11:AE15	AE11	=RIGHT(IFERROR(IF(INDIRECT("'"&C11&"'"&"!"&"K15")=0,"",INDIRECT("'"&C11&"'"&"!"&"K15")),""),8)
AF11:AF15	AF11	=IFERROR(IF(INDIRECT("'"&C11&"'"&"!"&"K16")=0,"",INDIRECT("'"&C11&"'"&"!"&"K16")),"")
AG11:AG15	AG11	=IFERROR(IF(INDIRECT("'"&C11&"'"&"!"&"C30")=0,"",INDIRECT("'"&C11&"'"&"!"&"c30")),"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
N11:N71	Other Type	Color scale		NO
I11:I5000	Cell Value	="DELAYED PROD. IMPL."	text	NO
I11:I5000	Cell Value	="WARNING"	text	NO
I11:I5000	Cell Value	="STARTED"	text	NO
I11:I5000	Cell Value	="ABORTED"	text	NO
I11:I5000	Cell Value	="ON TRACK"	text	NO
I11:I5000	Cell Value	="OPEN R&D TASK"	text	NO
I11:I5000	Cell Value	="FINISHED"	text	NO
I11:I5000	Cell Value	="OPEN SPD TASK"	text	YES

 

[dermie_72]

I find that when i'm sorting data like that, I need to reset my formulas at the top and drag them down. The formulas get jumbled when you sort. IE row 11 no longer looks at the reference data in row 11. Try resetting the formulas after the sort and see if that helps.