How do i sort largest to smallest across multiple classes, B-K, without mucking up my locked data in column A?

[catling94]

I am trying to sort exposure, largest to smallest by column K, but using the sort function isnt working. The company name is in column A, and doesnt change accordingly with the sort in K- I think this is because the data is locked via SUMIFs from other sheets. e.g.


=SUMIFS(Data!$AD$5:$AD$4708,Data!$BB$5:$BB$4708,Summary!$A$2,Data!$BF$5:$BF$4708,Summary!C$4,Data!$AZ$5:$AZ$4708,Summary!$A14)


How do i sort largest to smallest in K so that column A changes with it.

 

[RickXL]

Hi and welcome to the MrExcel Message Board.

When you select the columns to be sorted you need to include column A as well. Then choose custom sort and select the columns you want to sort on.